postgres-mcp

Postgres MCP is a protocol implementation designed to enable standardized interactions between AI agents and PostgreSQL databases. It offers robust features for database connection management and SQL operation execution, catering specifically to PostgreSQL environments.

pg_mcp register

pg_mcp unregister

Log out of the connection

pg_mcp query

Perform a SELECT query

pg_mcp insert

Insert data

pg_mcp update

Update data

pg_mcp delete

Delete data

pg_mcp create

Create a table

pg_mcp drop

Delete table

pg_mcp create_index

Create an index

pg_mcp drop_index

Delete the index

pg_mcp describe

Describe the table structure