# AnalyticDB PostgreSQL MCP Server AnalyticDB PostgreSQL MCP Server serves as a universal interface between AI Agents and AnalyticDB PostgreSQL
The server publishes 14 tools. What each one is for:
execute_select_sql — Execute SELECT SQL queries on the AnalyticDB PostgreSQL serverexecute_dml_sql — Execute DML (INSERT, UPDATE, DELETE) SQL queries on the AnalyticDB PostgreSQL serverexecute_ddl_sql — Execute DDL (CREATE, ALTER, DROP) SQL queries on the AnalyticDB PostgreSQL serveranalyze_table — Collect table statisticsexplain_query — Get query execution planadbpg_graphrag_upload — Description: Upload a text file (with its name) and file content to graphrag to generate a knowledge graphParameters — **adbpg_graphrag_query — Description: Query the graphrag using the specified query string and mode。Description — ** Upload a decision tree with the specified root_node. If the root_node does not exist, a new decision tree will be createdadbpg_llm_memory_add — Description: Add LLM long memoryadbpg_llm_memory_get_all — Description: Retrieves all memory records associated with a specific user, run or agentadbpg_llm_memory_search — Description: Retrieves memories relevant to the given query for a specific user, run, or agentThe server ships on PyPI as adbpg-mcp-server, so your MCP client can launch it on demand — there is no separate build step. Add the server block to your client's configuration, restart it, and the tools register themselves.
Configuration is passed through the environment: ADBPG_HOST, ADBPG_PORT, ADBPG_USER, ADBPG_PASSWORD, ADBPG_DATABASE, GRAPHRAG_API_KEY, GRAPHRAG_BASE_URL, GRAPHRAG_LLM_MODEL. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.
Among the AI and media services options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. AnalyticDB PostgreSQL's toolset — execute_select_sql, execute_dml_sql, execute_ddl_sql and 11 more — is a fair guide to whether it matches your workflow. It is maintained by aliyun; worth a glance at recent repository activity before you build anything load-bearing on it.
This entry was verified against AnalyticDB PostgreSQL's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.
| Tool | What it does |
|---|---|
| execute_select_sql | Execute SELECT SQL queries on the AnalyticDB PostgreSQL server |
| execute_dml_sql | Execute DML (INSERT, UPDATE, DELETE) SQL queries on the AnalyticDB PostgreSQL server |
| execute_ddl_sql | Execute DDL (CREATE, ALTER, DROP) SQL queries on the AnalyticDB PostgreSQL server |
| analyze_table | Collect table statistics |
| explain_query | Get query execution plan |
| adbpg_graphrag_upload | **Description:** Upload a text file (with its name) and file content to graphrag to generate a knowledge graph. |
| Parameters | ** |
| adbpg_graphrag_query | **Description:** Query the graphrag using the specified query string and mode。 |
| Description | ** Upload a decision tree with the specified root_node. If the root_node does not exist, a new decision tree will be created. |
| adbpg_llm_memory_add | **Description:** Add LLM long memory. |
| adbpg_llm_memory_get_all | **Description:** Retrieves all memory records associated with a specific user, run or agent. |
| adbpg_llm_memory_search | **Description:** Retrieves memories relevant to the given query for a specific user, run, or agent. |
| adbpg_llm_memory_delete_all | - **Description:** Delete all memory records associated with a specific user, run or agent. |
| Tools | The Tools tool exposed by this server. |
{
"mcpServers": {
"alibabacloud-adbpg": {
"command": "uvx",
"args": ["adbpg-mcp-server"],
"env": {
"ADBPG_HOST": "your-value",
"ADBPG_PORT": "your-value",
"ADBPG_USER": "your-value",
"ADBPG_PASSWORD": "your-value",
"ADBPG_DATABASE": "your-value",
"GRAPHRAG_API_KEY": "your-value",
"GRAPHRAG_BASE_URL": "your-value",
"GRAPHRAG_LLM_MODEL": "your-value"
}
}
}
}Add to claude_desktop_config.json, then restart Claude Desktop.
| Variable | Description | Required |
|---|---|---|
| ADBPG_HOST | Endpoint or connection string the server talks to. | Optional |
| ADBPG_PORT | Configuration value read at startup. | Optional |
| ADBPG_USER | Configuration value read at startup. | Optional |
| ADBPG_PASSWORD | Configuration value read at startup. | Optional |
| ADBPG_DATABASE | Configuration value read at startup. | Optional |
| GRAPHRAG_API_KEY | Credential the server authenticates with. | Yes |
| GRAPHRAG_BASE_URL | Endpoint or connection string the server talks to. | Yes |
| GRAPHRAG_LLM_MODEL | Configuration value read at startup. | Optional |
Build a programmable telecommunications stack for connecting telephony services with the Internet via a cloud-based utility.
Search built for AI, not humans — semantic web search that returns model-ready content, plus code context.
Answers, not links — delegate questions to Perplexity's search-grounded models and get cited responses back.
Give your assistant a voice — text-to-speech, voice cloning and audio tools from the ElevenLabs API.
Give your assistant a real code sandbox — isolated cloud VMs for actually running the code it writes.
The ML hub in your context window — search models, datasets, papers and run Spaces from the official server.