known-path
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-pathrevenue 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.
Why this exists
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.
How it works
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.”
Quickstart
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.mdOptional live DataHub
export DATAHUB_GMS_URL=http://localhost:8080
export DATAHUB_GMS_TOKEN=your_token
kp doctorSee also: DataHub Quickstart · DataHub MCP · DataHub Skills
Web workbench (enterprise UI)
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
Demo
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
...MCP & agents
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"
}
}
}Project layout
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 testsHackathon
Event | |
Compliance | |
License | |
Video script |
Remaining human step: record the <3 minute YouTube/Vimeo video and complete the Devpost form (not automated here).
Development
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.
Links
License
Copyright 2026 SeraKah-1
Licensed under the Apache License, Version 2.0.
This server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
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