AnalyticDB PostgreSQL MCP Server

1. execute_select_sql

Execute SELECT SQL queries on the AnalyticDB PostgreSQL server.

2. execute_dml_sql

Execute DML (INSERT, UPDATE, DELETE) SQL queries on the AnalyticDB PostgreSQL server.

3. execute_ddl_sql

Execute DDL (CREATE, ALTER, DROP) SQL queries on the AnalyticDB PostgreSQL server.

4. analyze_table

Collect table statistics.

5. explain_query

Get query execution plan.

6. adbpg_graphrag_upload

Upload a text file and its content to graphrag to generate a knowledge graph.

7. adbpg_graphrag_query

Query the graphrag using the specified query string and mode.

8. adbpg_graphrag_upload_decision_tree

Upload a decision tree with the specified root node.

9. adbpg_graphrag_append_decision_tree

Append a subtree to an existing decision tree at the node specified by root_node_id.

10. adbpg_graphrag_delete_decision_tree

Delete a sub-decision tree under the node specified by root_node_entity.

11. adbpg_llm_memory_add

Add LLM long memory with a specific user, run or agent.

12. adbpg_llm_memory_get_all

Retrieves all memory records associated with a specific user, run or agent.

13. adbpg_llm_memory_search

Retrieves memories relevant to the given query for a specific user, run, or agent.

14. adbpg_llm_memory_delete_all

Delete all memory records associated with a specific user, run or agent.

{
  "mcpServers": {
    "adbpg-mcp-server": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/adbpg-mcp-server",
        "run",
        "adbpg-mcp-server"
      ],
      "env": {
        "ADBPG_HOST": "host",
        "ADBPG_PORT": "port",
        "ADBPG_USER": "username",
        "ADBPG_PASSWORD": "password",
        "ADBPG_DATABASE": "database",
        "GRAPHRAG_API_KEY": "graphrag llm api key",
        "GRAPHRAG_BASE_URL": "graphrag llm base url",
        "GRAPHRAG_LLM_MODEL": "graphrag llm model name",
        "GRAPHRAG_EMBEDDING_MODEL": "graphrag embedding model name",
        "GRAPHRAG_EMBEDDING_API_KEY": "graphrag embedding api key",
        "GRAPHRAG_EMBEDDING_BASE_URL": "graphrag embedding url",
        "LLMEMORY_API_KEY": "llm memory api_key",
        "LLMEMORY_BASE_URL": "llm memory base_url",
        "LLMEMORY_LLM_MODEL": "llm memory model name",
        "LLMEMORY_EMBEDDING_MODEL": "llm memory embedding model name",
        "LLMEMORY_ENABLE_GRAPH": "enable graph engine for llm memory (Default: false)"
      }
    }
  }
}