fix(docs): fix ClickHouse port inconsistency and add apply-graph-schema.sh

Chaitanya Manikrequested to merge
ChaitanyaManik17/knowledge-graph:fix/823-clickhouse-port-schema-script into main

What

  1. Add scripts/apply-graph-schema.sh — a robust script to apply config/graph.sql statement-by-statement against a ClickHouse database
  2. Replace the brittle inline sed/tr pipeline in docs/dev/local-development.md with a call to the new script
  3. Clarify the two ClickHouse ports (native TCP 9001 vs HTTP 8123) in the troubleshooting section

Why

The inline sed pipeline in the docs is fragile: the -- comment strip breaks on any -- inside a string literal, and naive ; splitting can mangle statements. The docs also inconsistently reference ports 9001 and 8123 without explaining which is which.

How to test

  1. Start a local ClickHouse (per docs/dev/local-development.md)
  2. Run scripts/apply-graph-schema.sh against gkg-development
  3. Confirm tables exist: clickhouse client --port 9001 --database gkg-development --query "SHOW TABLES"
  4. Re-run the script — confirm it is idempotent (no errors)
  5. Run with --dry-run to verify statement parsing

Closes #823 (closed)

Merge request reports