Integrations
Provides tools for interacting with PostgreSQL databases, including CRUD operations, schema management (listing databases and tables, describing table structures, creating and altering tables), and executing SQL queries with optional query plan validation and read-only mode protection.
go-mcp-postgres
Overview
Copy code from https://github.com/Zhwt/go-mcp-mysql/ and with AI help, I change db from mysql to postgres.
Zero burden, ready-to-use Model Context Protocol (MCP) server for interacting with Postgres and automation. No Node.js or Python environment needed. This server provides tools to do CRUD operations on MySQL databases and tables, and a read-only mode to prevent surprise write operations. You can also make the MCP server check the query plan by using a EXPLAIN
statement before executing the query by adding a --with-explain-check
flag.
Please note that this is a work in progress and may not yet be ready for production use.
Installation
- Get the latest release and put it in your
$PATH
or somewhere you can easily access. - Or if you have Go installed, you can build it from source:
Usage
Method A: Using Command Line Arguments for stdio mode
Note: For those who put the binary outside of your $PATH
, you need to replace go-mcp-postgres
with the full path to the binary: e.g.: if you put the binary in the Downloads folder, you may use the following path:
Method B: Using Command Line Arguments for sse mode
./go-mcp-postgres --t sse --ip x.x.x.x --port nnnn --dsn postgresql://user:pass@host:port/db --lang en
Optional Flags
--lang
: Set language option (en/zh-CN), defaults to system language- Add a
--read-only
flag to enable read-only mode. In this mode, only tools beginning withlist
,read_
anddesc_
are available. Make sure to refresh/restart the MCP server after adding this flag. - By default, CRUD queries will be first executed with a
EXPLAIN ?
statement to check whether the generated query plan matches the expected pattern. Add a--with-explain-check
flag to disable this behavior.
Tools
Multi-language support: All tool descriptions will automatically localize based on lang parameter
If you want to add your own language support, please refer to the [locales](for i18n) folder. The new locales/xxx/active-xx.toml file should be created if you want to use it in command line.
Schema Tools
list_database
- ${mcp.tool.list_database.desc}
- Parameters: None
- Returns: A list of matching database names.
list_table
- ${mcp.tool.list_table.desc}
- Parameters:
name
: If provided, list tables with the specified name, Otherwise, list all tables.
- Returns: A list of matching table names.
create_table
- ${mcp.tool.create_table.desc}
- Parameters:
query
: The SQL query to create the table.
- Returns: x rows affected.
alter_table
- Alter an existing table in the Postgres server. The LLM is informed not to drop an existing table or column.
- Parameters:
query
: The SQL query to alter the table.
- Returns: x rows affected.
desc_table
- Describe the structure of a table.
- Parameters:
name
: The name of the table to describe.
- Returns: The structure of the table.
Data Tools
read_query
- Execute a read-only SQL query.
- Parameters:
query
: The SQL query to execute.
- Returns: The result of the query.
write_query
- Execute a write SQL query.
- Parameters:
query
: The SQL query to execute.
- Returns: x rows affected, last insert id: .
update_query
- Execute an update SQL query.
- Parameters:
query
: The SQL query to execute.
- Returns: x rows affected.
delete_query
- Execute a delete SQL query.
- Parameters:
query
: The SQL query to execute.
- Returns: x rows affected.
count_query
- Query the number of rows in a certain table..
- Parameters:
name
: The name of the table to count.
- Returns: The row number of the table.
Big thanks to https://github.com/Zhwt/go-mcp-mysql/ again.
License
MIT
This server cannot be installed
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
what is go-mcp-postgres? go-mcp-postgres is a Model Context Protocol (MCP) server designed for interacting with Postgres databases, allowing for easy CRUD operations and automation without the need for a Node.js or Python environment.
Related MCP Servers
- AsecurityAlicenseAqualityA beginner-friendly Model Context Protocol (MCP) server that helps users understand MCP concepts, provides interactive examples, and lists available MCP servers. This server is designed to be a helpful companion for developers working with MCP. Also comes with a huge list of servers you can install.Last updated -3936JavaScriptApache 2.0
- -securityFlicense-qualityA server implementing the Model Context Protocol (MCP) for Cursor that allows using a PostgreSQL database as storage for model contexts, enabling secure database exploration and querying.Last updated -JavaScript
- AsecurityAlicenseAqualityA dynamic service that creates and manages Model Context Protocol (MCP) servers, allowing users to spawn, customize, and control multiple MCP servers as child processes.Last updated -521TypeScriptMIT License
- -securityFlicense-qualityA Model Context Protocol server that enables performing PostgreSQL database operations (create, read, update, delete) on User and Post entities through MCP tools.Last updated -TypeScript