Go-MCP-Postgres is a ready-to-use MCP server for interacting with PostgreSQL databases, adapted from Zhwt's MySQL implementation. It provides tools for database schema management and CRUD operations with safety features like read-only mode and query plan validation. Written in Go with no external dependencies, it supports both stdio and SSE transport modes, includes multilingual support, and is particularly useful for database automation tasks without requiring Node.js or Python environments.
Aucun avis encore. Soyez le premier à donner votre avis !
Connectez-vous pour rejoindre la conversation
Returns a list of matching database names. Parameters: None.
Returns a list of matching table names. Parameters: name (optional string) - If provided, list tables with the specified name; otherwise, list all tables.
Creates a new table in the Postgres server. Parameters: query (string) - The SQL query to create the table.
Alters an existing table in the Postgres server. Parameters: query (string) - The SQL query to alter the table.
Describes the structure of a table. Parameters: name (string) - The name of the table to describe.
Executes a read-only SQL query. Parameters: query (string) - The SQL query to execute.
Executes a write SQL query. Parameters: query (string) - The SQL query to execute.
Executes an update SQL query. Parameters: query (string) - The SQL query to execute.
Executes a delete SQL query. Parameters: query (string) - The SQL query to execute.
Queries the number of rows in a certain table. Parameters: name (string) - The name of the table to count.
