Aix Db

v1.0.0Data Science & MLstable

Aix-DB 基于 LangChain/LangGraph 框架,结合 MCP Skills 多智能体协作架构,实现自然语言到数据洞察的端到端转换。

bigdatadeepseek-r1difyechartslamaindex
Share:
2,121
Stars
0
Downloads
0
Weekly
0/5

What is Aix Db?

Aix Db is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to aix-db 基于 langchain/langgraph 框架,结合 mcp skills 多智能体协作架构,实现自然语言到数据洞察的端到端转换。

Aix-DB 基于 LangChain/LangGraph 框架,结合 MCP Skills 多智能体协作架构,实现自然语言到数据洞察的端到端转换。

This server falls under the Data Science & ML category on MCPgee, the world's largest MCP server directory with 33,000+ servers.

Features

  • Aix-DB 基于 LangChain/LangGraph 框架,结合 MCP Skills 多智能体协作架构,实现自然

Use Cases

Natural language to data insights with LangChain/LangGraph
Multi-agent data analysis architecture
apconw

Maintainer

LicenseMIT
Languagejavascript
Versionv1.0.0
UpdatedMay 22, 2026
Statushealthy
Maintenanceactive

Works with

ClaudeOpenAIwindowsmacoslinux

Installation

Manual Installation

npx aix-db

Configuration

Configuration Details

Config File

claude_desktop_config.json

Performance

Response Metrics

Response Time< 200ms
ThroughputMedium

Resource Usage

Memory UsageLow
CPU UsageLow

How to Set Up and Use Aix Db

Aix-DB is an AI-powered data analytics platform built on LangChain and LangGraph that converts natural language questions into database queries, visualizations, and multi-agent data workflows using a MCP Skills architecture. It supports Text2SQL across more than eight database engines — including MySQL, PostgreSQL, Oracle, ClickHouse, and SQL Server — and enriches results with RAG-based knowledge retrieval via Neo4j and automated chart generation through ECharts. Developers and data analysts use it to query complex data warehouses conversationally without writing SQL, while the multi-agent layer handles orchestration, deep data exploration, and report generation.

Prerequisites

  • Docker and Docker Compose (recommended deployment method)
  • Python 3.11+ and pip or uv (for local development installs)
  • An LLM API key: OpenAI, Anthropic Claude, DeepSeek, Qwen, or a local Ollama instance
  • Access credentials for at least one supported database (MySQL, PostgreSQL, Oracle, ClickHouse, etc.)
  • Optional: Langfuse account for LLM observability tracing (LANGFUSE_SECRET_KEY, LANGFUSE_PUBLIC_KEY)
1

Clone the repository and prepare environment configuration

Clone the Aix-DB repository and copy the environment template. Edit .env to set your LLM API key and database connection details before starting the stack.

git clone https://github.com/apconw/Aix-DB.git
cd Aix-DB/docker
cp .env.template .env
2

Start the full stack with Docker Compose

Launch all services — the API backend, web frontend, PostgreSQL metadata store, and optional Neo4j graph store — with a single command.

docker-compose up -d
3

Access the web UI and log in

Open the Aix-DB web interface at http://localhost:18080 using the default credentials. Change the password after first login.

open http://localhost:18080
# Default credentials: admin / 123456
4

Register your database as a datasource

In the web UI, navigate to Datasources and add your database connection. Aix-DB supports MySQL, PostgreSQL, Oracle, SQL Server, ClickHouse, Doris, StarRocks, CSV, and Excel files.

5

Ask natural language questions against your data

In the Chat interface, select your datasource and type a question in natural language. Aix-DB generates SQL, executes it, and returns results with optional chart visualizations.

6

Use the CLI tool for scripted or automated queries

Install the aix-db-cli npm package to query your Aix-DB instance from scripts, CI pipelines, or MCP integrations.

npm install -g @apconw/aix-db-cli
aix-db-cli login
aix-db-cli chat "What were total sales by region last quarter?" --datasource 48 --stream

Aix Db Examples

Client configuration

Configure Aix-DB as an MCP server in your AI client. The server runs via npx and connects to a locally running Aix-DB instance.

{
  "mcpServers": {
    "aix-db": {
      "command": "npx",
      "args": ["aix-db"],
      "env": {
        "SERVER_HOST": "0.0.0.0",
        "SERVER_PORT": "8088"
      }
    }
  }
}

Prompts to try

Once connected to a datasource, ask analytical questions in plain language and Aix-DB handles the SQL and visualization automatically.

- "Show me total revenue by product category for the last 6 months as a bar chart."
- "Which customers have placed more than 5 orders but haven't purchased in the last 90 days?"
- "Generate a Text2SQL query to find the top 10 selling SKUs in the US market."
- "Compare monthly active users between this year and last year as a line chart."
- "Deep query: analyze churn trends and suggest which customer segments are at highest risk."

Troubleshooting Aix Db

Docker Compose fails to start with a port conflict on 18080 or 18088

Edit Aix-DB/docker/.env or docker-compose.yml to remap ports. Change -p 18080:80 to a free port (e.g., -p 8080:80) and update the SERVER_PORT variable accordingly.

Text2SQL queries return wrong results or fail with a syntax error

Aix-DB's SQL generation quality depends on the LLM model configured. Try switching to a more capable model (e.g., DeepSeek-R1 or GPT-4o) by updating the model setting in the .env file. Also ensure the datasource table schemas have been indexed by Aix-DB.

Web UI loads but chat returns no response and API logs show LLM timeout

Check that your LLM API key is correctly set in .env and that LLM_MAX_TOKENS is not set too high for your plan. The default is 65536 tokens — lower it if your LLM provider enforces stricter per-request limits.

Frequently Asked Questions about Aix Db

What is Aix Db?

Aix Db is a Model Context Protocol (MCP) server that aix-db 基于 langchain/langgraph 框架,结合 mcp skills 多智能体协作架构,实现自然语言到数据洞察的端到端转换。 It connects AI assistants to external tools and data sources through a standardized interface.

How do I install Aix Db?

Follow the installation instructions on the Aix Db GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.

Which AI clients work with Aix Db?

Aix Db works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.

Is Aix Db free to use?

Yes, Aix Db is open source and available under the MIT license. You can use it freely in both personal and commercial projects.

Browse More Data Science & ML MCP Servers

Explore all data science & ml servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.

Quick Config Preview

{ "mcpServers": { "aix-db": { "command": "npx", "args": ["-y", "aix-db"] } } }

Add this to your claude_desktop_config.json or .cursor/mcp.json

Read the full setup guide →

Ready to use Aix Db?

Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.

33,000+ ServersFree & Open SourceStep-by-Step Guides