enhanced-postgres-mcp-server

The PostgreSQL MCP Server (Enhanced) is a tool designed to provide comprehensive access to PostgreSQL databases through Model Context Protocol. It allows users to perform both read and write operations and manage database schemas using LLMs, paired with extensive tools and security features.

query

Perform read-only SQL query

execute

Execute SQL statements for data modification

insert

Insert a new record

update

Update records

delete

Delete records

createTable

Create a new table

createFunction

Create functions/processes

createTrigger

Create a trigger

createIndex

Create an index

alterTable

Modify the table structure