Generates trusted SQL queries targeting Snowflake data warehouses by selecting canonical tables and dimensions based on a route sheet and catalog metadata from DataHub.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@known-path revenue by region last quarter"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Data catalogs already know which table is canonical, which is deprecated, and who owns it.
Agents still thrash search and join the wrong revenue_* table.
known-path is a small activation layer on top of that catalog truth:
Load a short route sheet for the job
Light only the few assets that matter
Stop if trust is red (no invented replacements)
Emit SQL you could open a PR with
Write a route note so the next run starts smarter
Built for the DataHub Agent Hackathon — tracks Metadata-Aware Code Generation and Agents That Do Real Work.
Related MCP server: LOOM
flowchart LR
A[Job intent] --> B[Route sheet]
B --> C[Score & shortlist]
C --> D{Trust check}
D -->|red| E[Fail closed<br/>leave block note]
D -->|green| F[Fetch detail<br/>budgeted]
F --> G[SQL artifact]
G --> H[Write route note<br/>back to catalog/files]
subgraph Catalog truth
DH[(DataHub GMS<br/>or fixture stand-in)]
end
C -.-> DH
F -.-> DH
H -.-> DHMode | Behavior |
baseline | Naive name thrash — more fetches, often lights |
known-path | Route sheet + trust — lights canonical + region only |
blocked | Forces red trust — stops, does not invent a table |
This is not a second catalog, not a lineage UI, and not “dump all metadata into the prompt.”
git clone https://github.com/SeraKah-1/known-path.git
cd known-path
python -m venv .venv && source .venv/bin/activate # Windows: .venv\Scripts\activate
pip install -e ".[dev]"
kp doctor
kp demoArtifacts land in:
examples/baseline_wrong.sql
examples/revenue_by_region.sql
examples/runs/last_*.json
examples/runs/writeback_route_note.mdexport DATAHUB_GMS_URL=http://localhost:8080
export DATAHUB_GMS_TOKEN=your_token
kp doctorSee also: DataHub Quickstart · DataHub MCP · DataHub Skills
No extra deps (stdlib server). Every button runs the real CLI (python -m known_path.cli …).
kp web
# or:
python -m known_path.webapp --host 0.0.0.0 --port 8088
# open http://127.0.0.1:8088Panel | What you get |
Job intent + CTAs | Baseline / Known path / Fail closed / Full demo |
Activation graph | SVG nodes lit from last CLI plan |
Fetch comparison | Honest shared-axis bars (baseline vs known-path vs blocked) |
Catalog table | demo-finance assets + usage bars |
Agent terminal | Type |
kp dataset # list assets + pathUX notes: docs/UX_AND_RESOURCES.md
kp demoExpected story:
Step | Result |
Baseline | Higher fetch count; trap table can activate |
Known path |
|
Blocked | Status |
kp run --mode baseline -i "revenue by region last quarter"
kp run --mode known-path -i "revenue by region last quarter"
kp run --mode blocked -i "revenue by region last quarter"Sample SQL (generated):
-- known-path generated SQL
-- job: job.revenue_by_region_quarter
-- fact_urn: urn:li:dataset:(urn:li:dataPlatform:snowflake,finance.revenue_canonical,PROD)
SELECT
d.region_name AS region,
SUM(f.revenue_amount) AS revenue
FROM finance.revenue_canonical AS f
JOIN dim.region AS d
ON f.region_id = d.region_id
...Install MCP extra and run the server:
pip install -e ".[mcp]"
python -m known_path.mcp_serverTools: match_job · activate · ping_required · commit_route · explain_last_run
Skill package: skills/known-path/SKILL.md — workflow instructions agents load on demand (pairs with tools, does not replace them).
Example Cursor / Claude MCP snippet:
{
"mcpServers": {
"known-path": {
"command": "python",
"args": ["-m", "known_path.mcp_server"],
"cwd": "/path/to/known-path"
}
}
}known-path/
├── assets/ # logo + diagrams
├── cards/ # route sheets (YAML)
├── datasets/demo-finance/ # demo catalog.json + CSV samples
├── docs/HACKATHON.md # Devpost compliance map
├── docs/demo-recording/ # recorded demo video + evidence
├── examples/ # SQL + run records
├── skills/known-path/ # agent skill
├── src/known_path/ # library + CLI + MCP + web
├── apps/web/ # optional FastAPI wrapper
└── tests/ # real scoring/activation testsEvent | |
Compliance | |
License | |
Video script |
Remaining human step: record the <3 minute YouTube/Vimeo video and complete the Devpost form (not automated here).
pip install -e ".[dev]"
pytest -qCore policy lives in pure functions (scoring.py, ping.py, activate.py) so tests exercise the real logic with trap-vs-trusted fixtures.
Copyright 2026 SeraKah-1
Licensed under the Apache License, Version 2.0.
This server cannot be installed
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
MCP server providing access to the Scorecard API to evaluate and optimize LLM systems.
Remote MCP for A2A dependency inspector MCP, structured receipts, audit logs, and reviewer-ready evi
A paid remote MCP for CLI tool MCP, built to return verdicts, receipts, usage logs, and audit-ready
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/SeraKah-1/known-path'
If you have feedback or need assistance with the MCP directory API, please join our Discord server