DatI

DatI - Database Semantic Gateway for AI Agents

English | 简体中文

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: http://47.99.122.223:18085/

Account / Password: demo / demo123

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)

View Demo (GIF)

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

View Demo (GIF)

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

View Demo (GIF)

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

View Screenshot

5. Query Data in Agent

View Demo (GIF)

Why DatI?

1. Multi-Database Support: Supports MySQL, PostgreSQL, ClickHouse, Doris, and other relational and analytical databases
2. 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
3. Flexible Integration: Based on standard MCP (Streamable HTTP), easily integrates into your existing agents or workflows
4. 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
5. 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, startup, common commands, and development conventions
• Server Deployment Guide: Single-node Docker Compose deployment (no registry needed)
• 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/)
• Examples:
  • Family Finance Assistant: Multi-user collaborative bookkeeping, parameterized permission control, transparent SQL queries, and self-healing agent workflows
• Architecture & Design (Maintained continuously alongside code):
  • Overview
  • Authentication
  • Authorization
  • Data Source Module
  • Semantic Module
  • MCP Service Management
  • Template Engine
  • Editor Architecture
• 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)

Acknowledgments

Thanks to the LINUX DO community for discussions and support.