Enhanced Postgres MCP Server

🚀 PostgreSQL Model Context Protocol (MCP) Server (Enhanced Version)

A Model Context Protocol server that provides read and write access to PostgreSQL databases. This server enables Large Language Models (LLMs) to inspect database schemas, execute queries, modify data, and create/modify database schema objects.

⚠️ Important Note

This is an enhanced version of the original PostgreSQL MCP server developed by Anthropic. The original server only provided read-only access, while this enhanced version adds write capabilities and schema management features.

🚀 Quick Start

The PostgreSQL MCP Server (Enhanced Version) allows LLMs to interact with PostgreSQL databases. It provides various tools and resources for data querying, insertion, updating, and deletion, as well as schema creation.

✨ Features

Tools

Data Query

• query
  • Execute a read-only SQL query against the connected database.
  • Input: sql (Type: string)
  • Output: Return the query result or an error message.

Data Insertion

• insert
  • Insert new data into the specified table.
  • Input: table (Type: string), data (Type: object).
  • Output: Return the inserted SQL statement or an error message.

Data Update

• update
  • Update data in the specified table.
  • Input: table (Type: string), data (Type: object), where (Type: string).
  • Output: Return the updated SQL statement or an error message.

Table Deletion

• delete
  • Delete data from the specified table.
  • Input: table (Type: string), where (Type: string).
  • Output: Return the deleted SQL statement or an error message.

Resources

Data Query

/query [SQL query]

Data Insertion

/insert table="table_name", data={"field1": "value1", "field2": "value2"}

Data Update

/update table="table_name", data={"field1": "new_value1", "field2": "new_value2"}, where="condition"

💻 Usage Examples

Basic Usage

Query Data

/query SELECT * FROM users LIMIT 5

Insert Data

/insert table="users", data={"name": "John Doe", "email": "john@example.com"}

Update Data

/update table="users", data={"status": "inactive"}, where="id='123'"

Advanced Usage

Create Table

Create Function and Trigger

/createFunction name="update_timestamp", parameters="", returnType="TRIGGER", language="plpgsql", body="BEGIN NEW.updated_at = NOW(); RETURN NEW; END;"

🔧 Technical Details

Security Precautions

1. All data modification operations use transactions with proper commit/rollback handling.
2. Each operation returns the executed SQL statement to ensure transparency.
3. The server uses parameterized queries in insert/update operations to prevent SQL injection.

📄 License

This MCP server is released 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, see the LICENSE file in the project repository.