pgsql-mcp-server

The PostgreSQL MCP Server is a Model Context Protocol server tailored for managing and interacting with PostgreSQL databases. It facilitates SQL operations for AI assistants, ensuring secure and efficient database interactions.

read_query

Execute SELECT query and return query results

write_query

Execute INSERT, UPDATE, or DELETE query to modify database content

create_table

Create new tables, support custom table structure

list_tables

List all user tables in the database, support filtering by schema