DatI MCP server
Commit Nov 14, 2026Connects AI agents to enterprise databases by transforming them into secure, semantically enriched MCP services with built-in SQL tools.
Also known as yimindev/dati
- Stars
- 78
- Tools
- —
- Downloads, 30 days
- —
- Latest version
- —
- Last commit
- Nov 14, 2026
- License
- Apache-2.0
What is DatI MCP?
DatI connects AI agents to enterprise databases by transforming them into secure, semantically enriched MCP services with built-in SQL tools.
Summary generated from the project's README
About DatI MCP server
Connecting AI agents to enterprise databases through a semantic gateway is what dati enables for developers and data teams. By transforming relational databases like MySQL, PostgreSQL, ClickHouse, and Doris into MCP services, it allows agents to interact with complex data using natural language. The system uses semantic metadata, business terms, and column aliases to help models understand specific business jargon and locate the correct tables.
Users deploy the service via Docker Compose and manage it through a web interface. The platform provides built-in tools for schema inspection and SQL execution, alongside the ability to create parameterized SQL tools. Security is handled through centrally managed credentials with user-level permissions and data scope isolation. This setup allows for the creation of specialized MCP services that can be integrated into various agent hosts using streamable HTTP.
What you can do with it
- 1Conversational Data AnalysisAn AI agent can perform NL2SQL analysis by using semantic metadata and built-in tools to query business databases.
- 2Lightweight Application BuildingDevelopers can wrap existing databases as MCP services so agents can manage data through conversation.
- 3Automated Platform ManagementThe dati-ops skill allows for the automated configuration of data sources, subjects, and MCP services.
Written from the project's README. Every use case is checked against a quote from it.
Automated checks
Ran Nov 14, 2026Full report →Not verified yet. A server needs a score of 80, no serious finding, and enough data for us to check. How checks work · What to fix for more points
- Source repository linked and reachableyimindev/dati is public and reachablegithub.com/yimindev/dati ↗Pass
- Package names this repository as its sourceNot checked
- Build provenance (Sigstore attestation)Not checked
- Open source license (OSI)Apache-2.0spdx.org/licenses/Apache-2.0.html ↗Pass
- Commit or release in the last yearLast commit or release 2026-11-14github.com/yimindev/dati ↗Pass
- OpenSSF ScorecardNot checked
- Package name not close to a popular packageNot checked
- No critical advisory in the package or its dependenciesNot checked
- No hidden instructions to the model0 tool descriptions and the README read; no override phrases, credential paths or hidden charactersPass
- Destructive tools are labelledNot checked
- Remote endpoint answers the MCP handshakeNot checked
README
View on GitHubDatI - Database Semantic Gateway for AI Agents
DatI (Data Intelligence) is a lightweight semantic gateway connecting AI Agents with enterprise databases. Simply connect your database, enrich semantic metadata, and configure built-in or parameterized SQL tools to publish an MCP service — ready for your agents or any MCP host.
┌────────────────────┐ ┌────────────────────┐ ┌────────────────────┐
│ User A: OpenCode │ │ User B: WorkBuddy │ │ User N: DataAgent │
└──────────┬─────────┘ └──────────┬─────────┘ └──────────┬─────────┘
└───────────────────────┼───────────────────────┘
▼ MCP (Streamable HTTP)
┌─────────────────────────────── DatI ───────────────────────────────┐
│ Semantic │ Security │ Tools │
└──────────────────────────────────┬─────────────────────────────────┘
▼
┌────────────────────────────────────────────────────────────────────┐
│ MySQL │ PostgreSQL │ ClickHouse │ Doris │
└────────────────────────────────────────────────────────────────────┘
Try It Online
Demo URL: https://dati-demo.zhangyimin.me
The demo instance is preloaded with sample data and reset periodically.
Demo
Data and configuration reference the AdventureWorks sample and can be automated via the dati-ops skill.
1. Data Source Metadata Configuration (configurable tables, columns, and values)

2. Business Subject Configuration (select relevant tables, define business terms)

3. MCP Service Configuration (choose business subjects, enable built-in tools, add parameterized SQL tools)

4. Configure MCP in Agent (e.g., Antigravity)

5. Query Data in Agent

Quick Start
git clone https://github.com/yimindev/dati.git && cd dati
cp .env.example .env # Configure JWT_SECRET and ES password
docker compose up -d
Open http://localhost:8085. Register with username admin to get super admin role. For production tuning and external DB setup, see Deployment Guide.
Why DatI?
- Multi-Database Support: Supports MySQL, PostgreSQL, ClickHouse, Doris, and other relational and analytical databases
- Semantic Enhancement: Supports business terms, column aliases, and automatic enum dictionary extraction. Combined with semantic search, it helps models understand business jargon and find the right tables
- Flexible Integration: Based on standard MCP (Streamable HTTP), easily integrates into your existing agents or workflows
- Effortless MCP Publishing: Ready-to-use built-in tools (schema inspection, SQL execution) and parameterized SQL tools to publish MCP services with zero extra deployment
- Security & Governance: Centrally managed database credentials with user-level permission and data scope isolation
Use Cases
- Conversational Data Analysis (NL2SQL): Connect business databases and support NL2SQL analysis workflows with semantic metadata and built-in tools
- Lightweight App Development: Wrap databases as MCP services so agents can query and update data through conversation to build lightweight applications
Tech Stack
- Backend: Spring Boot 3.5.x + Java 21 + JPA
- Frontend: Vue 3 + TypeScript + Vite + Element Plus + TailwindCSS 4
- Database: H2 (Development) / MySQL / PostgreSQL (Production)
- Search Engine: Elasticsearch (Semantic Retrieval)
Documentation
- Local Development Guide: Environment setup, backend/frontend startup, and project conventions
- Server Deployment Guide: Architecture overview, Docker Compose deployment, and operational maintenance
- Architecture Overview: High-level architecture, module index, and key design conventions
- Examples:
- Enterprise BI & Retail Analytics (AdventureWorks DW): Star schema Text-to-SQL, metric governance, multi-table joins, and parameterized acceleration
- Family Finance Assistant: Multi-user collaborative bookkeeping, parameterized permission control, transparent SQL queries, and self-healing agent workflows
- Agent Skills (Agent Skills Open Standard, auto-discovered by repository agents):
- dati-ops: User Skill — Configure and operate the platform via HTTP APIs (data sources, subjects & terms, MCP services); self-contained with built-in openapi.json and query tools, independently distributable; connected in-repo via
.agents/skills/dati-ops/ - e2e-tester: Developer Skill — E2E HTTP integration tests and API behavior validation (see test cases in e2e-tests/test-cases/)
- dati-ops: User Skill — Configure and operate the platform via HTTP APIs (data sources, subjects & terms, MCP services); self-contained with built-in openapi.json and query tools, independently distributable; connected in-repo via
- User Guide: docs/user-guide (VitePress site, bilingual)
- API Specification: docs/api/openapi.json (Used by E2E test toolchains)
- AI Coding Assistant Guidelines: AGENTS.md and .agents/rules/ (Backend, frontend, and design system rules)
Community
-
Articles: DEV.to Series (DatI Devlog)
-
Discussions: LINUX DO
-
WeChat Official Account:
DatI MCP questions
Which databases are supported by DatI?
DatI supports MySQL, PostgreSQL, ClickHouse, Doris, and other relational and analytical databases.
How does DatI help AI models understand business data?
It provides semantic enhancement through business terms, column aliases, and automatic enum dictionary extraction, combined with semantic search.