DatI - Database Semantic Gateway for AI Agents

DatI (Data Intelligence) is a lightweight semantic gateway connecting AI Agents with enterprise databases. Simply connect a database, configure semantic metadata, and enable prebuilt or parameterized SQL tools to publish an MCP service that connects with 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.

Why DatI?

Multiple Databases: 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
Fast to Build: Out-of-the-box prebuilt tools (metadata inspection, SQL execution) and parameterized SQL tools to publish MCP services without extra deployment
Access Control: Centrally manages credentials with support for user-level permission isolation

Use Cases

Natural Language Data Analysis: Connect business databases and support NL2SQL analysis workflows with metadata configuration and prebuilt 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):
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)