data-agent-service
Enables natural-language querying of Databricks warehouses, grounding answers in schema and business definitions from the catalog.
Enables natural-language querying of PostgreSQL databases, grounding answers in schema and business definitions from the catalog.
Used for provisioning real Azure resources in production, part of the deployment stack.
Click on "Deploy 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., "@data-agent-serviceWhich support team resolves tickets fastest per our catalog definition?"
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 Agent Service
Ask your data warehouse a question in English. Get an answer you can defend.
Natural-language questions over the warehouses, databases and APIs you already have — Fabric and Azure SQL, PostgreSQL, Databricks, and any REST service including a retrieval one — grounded in the glossary, metrics and schema held in OpenMetadata. Each query is authorized twice: role rules in the service, then the source itself under the caller's own identity. Any MCP client, unchanged against real Azure.
📖 Documentation site — the full
reference, also browsable as Markdown in docs/.
Why this exists
"Which support team resolves tickets fastest?" has a right answer only if everyone agrees what resolves means. Point a general-purpose SQL agent at the warehouse and it will infer that from column names, fluently and with no warning when it is wrong.
On this repository's own seeded data, that inference names the wrong team. Wall-clock elapsed time says Frontline is fastest and Billing is worst. The business's actual definition — Resolution Time, which excludes hours spent waiting on the customer — reverses it: Billing is fastest. A wrong winner is not a rounding error, and nothing in the answer would tell you it happened.
This service is built so that class of error is structurally hard rather than merely unlikely.
What you get | How | Proof |
Meaning comes from your catalog, not the model | Glossary terms, metric formulas and column descriptions are read from OpenMetadata at query time. Business semantics are never baked into a prompt |
|
Every answer runs as the person asking | The user's token is exchanged on-behalf-of all the way to the engine, so row and column permissions are the engine's decision, not the agent's |
|
It cannot write, wander, or work around a refusal | One read-only |
|
It answers with its reasoning attached | The figure, the definition applied, the tables it came from, and any caveat the catalog raised |
|
A question that keeps recurring becomes a governed dashboard | The promoter counts templates, not questions — no natural language is stored. A released candidate is published to Power BI, Superset and Tableau from one | |
Bring your own model, and your own LLM gateway | Two wire protocols rather than one integration per vendor: Anthropic Messages and OpenAI chat completions reach LiteLLM, TrueFoundry, Azure OpenAI, OpenRouter, vLLM and the rest. A backend declares what it cannot do, and a deployment has to accept that in writing |
|
Any MCP client, no custom code | Claude, Cursor, VS Code and the SDKs connect over standard MCP with OAuth discovery | |
Runs on your laptop, deploys to real Azure unchanged | The whole stack runs on the emulator family; switching to Fabric, APIM and Entra is configuration, not a code path | |
Nothing here is claimed without something that checks it | Every capability carries a command that proves it; where something is designed but not built, the docs say so | the witnesses badge above, live from |
Status: Phases 0-16 landed — see docs/00-plan.md.
Related MCP server: Interactive Database Analyst via MCP
Quick start
make doctor # toolchain, docker, ~14 GB memory
make up # entra, keyvault, arm, fabric (+ SQL Server), OpenMetadata 1.13.2, apim
make status # "stack OK" is the verdictThen make seed, make test, make eval, make load, make ask Q="…" —
or make stack to do the whole bring-up from nothing, which is what CI runs.
What is here
Path | Purpose |
| Emulators and OpenMetadata are pinned, published images used as-is. Only this repo's own services build — plus |
| Every |
| Architecture, decisions, phases, evaluation, load, authz, extension |
| Quickstart, architecture, authorization, classification, evaluation, load, MCP clients, adding a source, production, CI |
| The warehouse-query executor (Python and Go), and the contract both answer to |
| What keeps being asked, and the |
| A second generator held to the same recorded bytes — deterministic output, checked rather than described |
| The agent, the accuracy suite, and the witnesses |
| Datasets, warehouse provisioning, OpenMetadata semantics, identity setup |
| Terraform for real Azure; |
| Six jobs; |
| The docs site — Astro + Starlight, generated from |
|
|
Discipline
Emulators and OpenMetadata are never modified; suspected bugs go to
docs/upstream-issues.md.No emulator-only code paths. Standard protocols only (OIDC/OAuth2 incl. OBO, managed-identity App Service protocol, TDS FedAuth, ARM, Graph, OM REST/MCP).
ENV=prodswaps.envand nothing else.
Emulator family
Built on entra-emulator, azure-keyvault-emulator, arm-emulator, fabric-emulator, azure-apim-emulator; composed per azure-emulators.
data-agent-voice is the voice front end over this service: it consumes this MCP surface, and every question still runs as the asking user. Its ledger and this one answer adjacent questions, so a claim about the whole path is only as strong as the weaker of the two.
Tier: intermediate — emulates nothing, and is consumed by data-agent-voice.
License
Apache-2.0.
This server cannot be deployed
Maintenance
Related MCP Connectors
Ask questions in plain language, get answers from your business database. No SQL required.
Ask data questions in natural language. Get SQL, insights, and charts from your databases.
Ask business questions in plain English. Get instant answers from your database, no SQL needed.
Query BigQuery, Snowflake, Redshift & Azure Synapse with natural language
Related MCP Servers
- FlicenseNot gradedqualityCmaintenanceEnables natural language querying of SQL databases with robust safety guarantees including read-only enforcement, AST validation, and row caps.-
- FlicenseNot gradedqualityCmaintenanceEnables natural-language querying of PostgreSQL databases with schema grounding and self-correcting error recovery. Provides a live audit trace and verifies results through exploratory decomposition and empty-result sanity checks.-
- FlicenseNot gradedqualityCmaintenanceProvides a guarded semantic layer for text-to-SQL, offering tools for schema discovery, semantic profiling, and query verification to enable safe and reliable SQL generation on enterprise databases.-
- FlicenseNot gradedqualityCmaintenanceEnables natural-language querying of SQLite databases through a governed semantic layer, with citations and typed abstention for PII or uncertified data.-