Facilitates PostgreSQL database operations by exposing query execution, schema introspection, and migration tools over standard I/O.
Pgmcp functions as a specialized MCP server for PostgreSQL databases, developed in Go. It simplifies database interactions by offering a comprehensive set of operations accessible via standard I/O. This includes capabilities to efficiently execute SQL queries, retrieve lists of tables, describe table structures, analyze query execution plans, and manage database migrations. Pgmcp serves as a robust backend for integrating core PostgreSQL functionalities into various development workflows and applications.
主要功能
01Explain query execution plans via stdio
02Execute SQL queries via stdio
0315 GitHub stars
04List database tables via stdio
05Describe table schemas via stdio
06Run database migrations via stdio
使用案例
01Integrating advanced database operations into custom applications
02Automating PostgreSQL database interactions within scripts
03Programmatically managing database schema evolution and updates
