AnalyticDB PostgreSQL MCP Server

Example Use Cases

• 1

  Execute and manage SQL (SELECT, DML, DDL) against an AnalyticDB PostgreSQL instance programmatically.

• 2

  Discover and fetch database metadata such as schemas, table DDL, and statistics to plan or validate queries.

• 3

  Integrated knowledge graph (graphrag) uploads/queries and long-term LLM memory to augment database-driven reasoning.

Description

This MCP server provides a universal interface between AI agents and AnalyticDB PostgreSQL, enabling execution of SELECT/DML/DDL, schema and table metadata retrieval, statistics collection, and query explanation. It supports streamable-HTTP and stdio transports for integration with MCP clients, and includes built-in features to upload/query knowledge to graphRAG and to store/search long-term LLM memory. The project is distributed as source or via PyPI and requires external LLM/embedding service credentials for the graph and memory integrations.