LogoSTMCP
Download
alibabacloud-adbpg-mcp-server

AnalyticDB PostgreSQL MCP Server

AnalyticDB PostgreSQL MCP Server provides a universal interface between AI Agents and AnalyticDB PostgreSQL databases, enabling seamless metadata retrieval and SQL operations execution.

Tools

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.

Open Graph image for AnalyticDB PostgreSQL MCP Server

JSON Config

{
  "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)"
      }
    }
  }
}

Useful Links

GitHubDeepWiki

Information

  • Author@aliyun
  • Published date2025/09/13

Categories

Tags

Back

More MCP Server

inoyu-mcp-unomi-server

Inoyu Apache Unomi MCP Server

@sergehuber/inoyu-mcp-unomi-server

A Model Context Protocol server enabling Claude to maintain user context through Apache Unomi profile management, featuring profile lookup, property management, consent handling, and GDPR-compliant operations.

npxstdio
inner-monologue-mcp

Inner Monologue MCP Server 🧠

@abhinav-mangla/inner-monologue-mcp

An MCP server implementing Google DeepMind's Inner Monologue concept, enabling LLMs to engage in private, structured self-reflection and multi-step reasoning before generating responses, improving response quality and problem-solving capabilities.

npxstdio
influxdb-mcp-server

InfluxDB MCP Server

@idoru/influxdb-mcp-server

An MCP server providing Claude AI access to InfluxDB with resources, tools, and prompts for time-series data management, query execution, and database operations.

npxstdio