alibabacloud-adbpg-mcp-server
If you are the rightful owner of alibabacloud-adbpg-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
AnalyticDB PostgreSQL MCP Server serves as a universal interface between AI Agents and AnalyticDB PostgreSQL databases.
The AnalyticDB PostgreSQL MCP Server is designed to facilitate seamless communication between AI Agents and AnalyticDB PostgreSQL databases. It acts as a bridge, allowing AI Agents to retrieve database metadata and execute SQL operations efficiently. This server supports various SQL operations, including SELECT, DML, and DDL queries, and provides tools for analyzing tables and explaining query execution plans. It can be integrated into different environments using either a direct download from GitHub or through pip installation. The server requires specific environment variables to connect to the AnalyticDB PostgreSQL instance, ensuring secure and efficient database interactions. With built-in resources and resource templates, users can easily access database schemas, tables, and statistics, making it a versatile tool for database management and AI integration.
Features
- Seamless integration with AnalyticDB PostgreSQL databases.
- Supports execution of SELECT, DML, and DDL SQL queries.
- Provides tools for table analysis and query execution plans.
- Offers built-in resources and templates for easy database access.
- Configurable via environment variables for secure connections.
Tools
execute_select_sql
Performing SELECT SQL Query on AnalyticDB PostgreSQL Server
execute_dml_sql
Execute DML (INSERT, UPDATE, DELETE) SQL query on AnalyticDB PostgreSQL server
execute_ddl_sql
Execute DDL (CREATE, ALTER, DROP) SQL query on AnalyticDB PostgreSQL server
analyze_table
Collect table statistics information
explain_query
Get query execution plan
