Enhanced PostgreSQL MCP Server
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.
Integrations
Supports running the PostgreSQL MCP server in a Docker container, with configuration options for connecting to PostgreSQL databases.
Provides both read and write access to PostgreSQL databases, allowing for data querying, data modification (insert, update, delete), and schema management (creating tables, functions, triggers, indexes).
PostgreSQL MCP Server (Enhanced)
A Model Context Protocol server that provides both read and write access to PostgreSQL databases. This server enables LLMs to inspect database schemas, execute queries, modify data, and create/modify database schema objects.
Note: This is an enhanced version of the original PostgreSQL MCP server by Anthropic. The original server provides read-only access, while this enhanced version adds write capabilities and schema management.
Components
Tools
Data Query
- query
- Execute read-only SQL queries against the connected database
- Input:
sql
(string): The SQL query to execute - All queries are executed within a READ ONLY transaction
Data Modification
- execute
- Execute a SQL statement that modifies data (INSERT, UPDATE, DELETE)
- Input:
sql
(string): The SQL statement to execute - Executed within a transaction with proper COMMIT/ROLLBACK handling
- insert
- Insert a new record into a table
- Input:
table
(string): The table namedata
(object): Key-value pairs where keys are column names and values are the data to insert
- update
- Update records in a table
- Input:
table
(string): The table namedata
(object): Key-value pairs for the fields to updatewhere
(string): The WHERE condition to identify records to update
- delete
- Delete records from a table
- Input:
table
(string): The table namewhere
(string): The WHERE condition to identify records to delete
Schema Management
- createTable
- Create a new table with specified columns and constraints
- Input:
tableName
(string): The table namecolumns
(array): Array of column definitions with name, type, and optional constraintsconstraints
(array): Optional array of table-level constraints
- createFunction
- Create a PostgreSQL function/procedure
- Input:
name
(string): Function nameparameters
(string): Function parametersreturnType
(string): Return typelanguage
(string): Language (plpgsql, sql, etc.)body
(string): Function bodyoptions
(string): Optional additional function options
- createTrigger
- Create a trigger on a table
- Input:
name
(string): Trigger nametableName
(string): Table to apply trigger tofunctionName
(string): Function to callwhen
(string): BEFORE, AFTER, or INSTEAD OFevents
(array): Array of events (INSERT, UPDATE, DELETE)forEach
(string): ROW or STATEMENTcondition
(string): Optional WHEN condition
- createIndex
- Create an index on a table
- Input:
tableName
(string): Table nameindexName
(string): Index namecolumns
(array): Columns to indexunique
(boolean): Whether the index is uniquetype
(string): Optional index type (BTREE, HASH, GIN, GIST, etc.)where
(string): Optional condition
- alterTable
- Alter a table structure
- Input:
tableName
(string): Table nameoperation
(string): Operation (ADD COLUMN, DROP COLUMN, etc.)details
(string): Operation details
Resources
The server provides schema information for each table in the database:
- Table Schemas (
postgres://<host>/<table>/schema
)- JSON schema information for each table
- Includes column names and data types
- Automatically discovered from database metadata
Usage with Claude Desktop
To use this server with the Claude Desktop app, add the following configuration to the "mcpServers" section of your claude_desktop_config.json
:
Docker
- when running docker on macos, use host.docker.internal if the server is running on the host network (eg localhost)
- username/password can be added to the postgresql url with
postgresql://user:password@host:port/db-name
- add
?sslmode=no-verify
if you need to bypass SSL certificate verification
NPX
Replace /mydb
with your database name.
Example Usage
Query Data
Insert Data
Update Data
Create a Table
Create a Function and Trigger
Building
Docker:
Security Considerations
- All data modification operations use transactions with proper COMMIT/ROLLBACK handling
- Each operation returns the SQL that was executed for transparency
- The server uses parameterized queries for insert/update operations to prevent SQL injection
License
This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
This server cannot be installed
A Model Context Protocol server providing both read and write access to PostgreSQL databases, enabling LLMs to query data, modify records, and manage database schemas.