Alibaba Cloud AnalyticDB for PostgreSQL
Free阿里云 AnalyticDB for PostgreSQL 官方集成，连接 AnalyticDB for PostgreSQL 实例，查询和分析数据。
FreeFree tier
About Alibaba Cloud AnalyticDB for PostgreSQL
AnalyticDB PostgreSQL MCP Server is an open-source universal interface that bridges AI Agents with Alibaba Cloud AnalyticDB PostgreSQL databases. It enables seamless communication, allowing AI agents to automatically retrieve database metadata (such as table schemas, indexes, and constraints) and execute SQL operations. The server can be run in stdio or Streamable-HTTP transport modes, configured via environment variables, and integrates with GraphRAG for enhanced AI capabilities. It is available for installation from PyPI or source code, making it suitable for both development and production use.
Key Features
Retrieve database metadata (tables, schemas, columns) automatically
Execute SQL operations through AI Agent commands
Support for stdio and Streamable-HTTP transport modes
Easy installation via pip or source code (uv/pip)
Environment variable configuration for database connection and GraphRAG integration
Secure authentication token support for HTTP mode
Official Alibaba Cloud open-source project (MIT license)
Pros & Cons
Pros
- Open-source and free to use
- Official support from Alibaba Cloud
- Simple setup with pip or uv
- Flexible transport options (stdio for MCP clients, HTTP for REST APIs)
- Supports authentication for secure HTTP deployments
Cons
- Limited to Alibaba Cloud AnalyticDB PostgreSQL databases
- Requires Python 3.x and dependency management (uv or pip)
- Documentation currently only available on GitHub in English
- No built-in GUI or web dashboard; relies on MCP client configuration
Best For
AI-powered database querying and analysisBuilding AI assistants that interact with AnalyticDB PostgreSQLAutomating database schema discovery for AI agentsIntegrating GraphRAG with relational databases for knowledge retrieval
FAQ
What is AnalyticDB PostgreSQL MCP Server?
It is an open-source MCP server that provides a universal interface between AI Agents and AnalyticDB PostgreSQL databases, allowing agents to retrieve metadata and execute SQL.
How do I install the server?
Install via PyPI using 'pip install adbpg-mcp-server' or clone the repository and install from source with 'uv pip install -e .'.
What transport modes are supported?
The server supports stdio (default for MCP clients) and Streamable-HTTP (for direct API access or debugging).
Is authentication supported?
Yes, in HTTP mode you can set an authentication token via the --auth-token flag or the MCP_AUTH_TOKEN environment variable.
Which environment variables are required?
You need to set ADBPG_HOST, ADBPG_PORT, ADBPG_USER, ADBPG_PASSWORD, ADBPG_DATABASE, and optionally GraphRAG variables (GRAPHRAG_API_KEY, GRAPHRAG_BASE_URL, etc.).