tyrchen/postgres-mcp

Postgres MCP is a Model Context Protocol (MCP) implementation for PostgreSQL databases. It provides a standardized interface for AI agents to interact with PostgreSQL databases through a set of well-defined commands.
## Features
Connection Management
Register and unregister database connections
Support for multiple concurrent database connections
Connection pooling for efficient resource management
Database Operations
Execute SELECT queries
Insert new records
Update existing records
Delete records
Create and drop tables
Create and drop indexes
Describe table structures
List tables in a schema
SQL Validation
Built-in SQL parser for validating statements
Support for PostgreSQL-specific syntax
Safety checks to ensure only allowed operations are performed
## Installation
bash
cargo install postgres-mcp
## Usage
### Configuration
Add the following to your MCP configuration file:
json
"mcpServers": {
"postgres": {
"command": "postgres-mcp",
"args": ["stdio"]
or run it in SSE mode:
First, start the postgres-mcp server in SSE mode:
bash
postgres-mcp sse
Then, configure the MCP config file to use the SSE mode:
json
"mcpServers": {
"postgres": {
"url": "http://localhost:3000/sse"
Once you started the postgres-mcp server, you should see the status of the MCP config is green, like this (cursor):
And then you could interact with it via the agent, like this (cursor):
### Commands
#### Register a Database Connection
bash
pgmcp register "postgres://postgres:postgres@localhost:5432/postgres"
# Returns a connection ID (UUID)
#### Unregister a Connection
bash
pgmcp unregister
#### Execute a SELECT Query
bash
pgmcp query "SELECT FROM users"
#### Insert Data
bash
pgmcp insert "INSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com')"
#### Update Data
bash
pgmcp update "UPDATE users SET name = 'Jane Doe' WHERE id = 1"
#### Delete Data
bash
pgmcp delete "users" "1"
#### Create a Table
bash
pgmcp create "CREATE TABLE users (id SERIAL PRIMARY KEY, name VARCHAR(255), email VARCHAR(255))"
#### Drop a Table
bash
pgmcp drop "users"
#### Create an Index
bash
pgmcp createindex "CREATE INDEX idxusersname ON users (name)"
#### Drop an Index
bash
pgmcp dropindex "idxusersname"
#### Describe a Table
bash
pgmcp describe "users"
## Dependencies
Rust 1.70 or later
PostgreSQL 12 or later
Required Rust crates: