</>MCP Agents Market
Agent

Datus-agent

by Datus-ai1.7kPythonUpdated 2026-09-07

The Future of Data Engineering — A CLI SQL client for the modern data stack, enabling AI-native context engineering for data.

Claude DesktopCursor

Datus-agent is an open-source data engineering AI agent that transforms natural language queries into accurate SQL through domain-aware reasoning and a continuously evolving knowledge base. It combines an interactive CLI for data exploration with the ability to create scoped subagents—chatbots with curated context, metrics, and business rules—that can be delivered to analysts via web interface, REST API, or MCP protocol. The agent builds a living context layer from schema metadata, reference SQL, semantic models, and domain knowledge, improving accuracy with every interaction. It supports 10+ LLM providers (OpenAI, Claude, Gemini, DeepSeek, and more) and connects to 11+ databases including PostgreSQL, Snowflake, ClickHouse, and DuckDB.

Key Features

Evolvable context engine that captures schema metadata, reference SQL, semantic models, and metrics in a unified LanceDB-powered knowledge base
Subagent creation: package mature domains into scoped chatbots with curated tools and business rules, delivered via web, API, or MCP
MetricFlow integration for semantic layer support—define business metrics in YAML and generate SQL from metric queries
Built-in evaluation framework with BIRD and Spider 2.0-Snow benchmark support to measure SQL accuracy
Multi-LLM support with per-node model assignment across 10+ providers (OpenAI, Claude, Gemini, DeepSeek, Qwen, OpenRouter)
11+ database adapters including SQLite, DuckDB, PostgreSQL, MySQL, Snowflake, ClickHouse, StarRocks, and Trino
MCP protocol implementation: acts as both an MCP server (exposing tools to Claude Desktop/Cursor) and MCP client (consuming external tools)
Skills marketplace integration with agentskills.io-style packaged tools and configurable permissions

Use Cases

  • 01Data engineers exploring databases interactively with natural language queries and building reusable context layers
  • 02Creating domain-specific analytics chatbots for business analysts with embedded metrics and business logic
  • 03Converting existing BI dashboard queries into conversational analytics via Dashboard Copilot
  • 04Benchmarking and tracking SQL generation accuracy as semantic context evolves over time
  • 05Integrating data query capabilities into Claude Desktop, Cursor, or other MCP-compatible AI assistants
  • 06Building REST API endpoints that translate natural language requests into SQL queries for applications

Related Agents

View more

Datus-agent — FAQ

What is Datus-agent?+

Datus-agent is an open-source data engineering AI agent that converts natural language into SQL queries using a continuously learning knowledge base. It can be used as a CLI tool, web chatbot, REST API, or MCP server, and allows you to create domain-specific subagents for analysts.

How do I install Datus-agent?+

On Linux or macOS, run the one-liner installer: curl -fsSL https://raw.githubusercontent.com/datus-ai/datus-agent/main/install.sh | sh. This creates a dedicated virtual environment at ~/.datus/venv and adds CLI commands to ~/.local/bin. Alternatively, install manually via pip install datus-agent.

Which AI clients work with Datus-agent?+

Datus-agent works with any MCP-compatible client including Claude Desktop and Cursor when run as an MCP server via datus-mcp. It also provides its own web interface (Streamlit), REST API, and interactive CLI.

What API keys or prerequisites does Datus-agent need?+

You need an API key from at least one LLM provider (OpenAI, Anthropic Claude, Google Gemini, DeepSeek, etc.) configured via the /model command or in agent.yml. Database connections require appropriate credentials for your target database. Python 3.12 is installed automatically by the one-liner installer.

Is Datus-agent free to use?+

Yes, Datus-agent is open-source under the Apache 2.0 license. However, you'll incur costs from your chosen LLM provider (OpenAI, Claude, etc.) based on API usage.

What databases does Datus-agent support?+

Datus-agent supports 11+ databases including built-in SQLite and DuckDB, plus pluggable adapters for PostgreSQL, MySQL, Snowflake, ClickHouse, StarRocks, Trino, Spark, Hive, Oracle, and more via the datus-db-adapters packages.

How do I install Datus-agent?+

Open the source repository on GitHub and follow its README. Datus-agent is a agent — MCP Agents Market links you directly to the official repo.

Is Datus-agent free?+

Datus-agent is an open-source project hosted on GitHub. Check the repository for its license and any usage requirements.

Related searches