MCP-Mirror/GarethCott_enhanced-postgres-mcp-server

3.1

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.

Tools

Functions exposed to the LLM to take actions

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

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client