GarethCott_enhanced-postgres-mcp-server

3.2

If you are the rightful owner of GarethCott_enhanced-postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The PostgreSQL MCP Server (Enhanced) is a Model Context Protocol server that provides both read and write access to PostgreSQL databases, allowing for comprehensive database management.

query

Execute read-only SQL queries against the connected database

execute

Execute a SQL statement that modifies data (INSERT, UPDATE, DELETE)

insert

Insert a new record into a table

update

Update records in a table

delete

Delete records from a table

createTable

Create a new table with specified columns and constraints

createFunction

Create a PostgreSQL function/procedure

createTrigger

Create a trigger on a table

createIndex

Create an index on a table

alterTable

Alter a table structure