MCP Catcher › database › PostgreSQL MCP
PostgreSQL MCP
MCP server enabling direct PostgreSQL database queries from AI
MCP server providing PostgreSQL database connectivity. Supports AI-assisted table creation, data insertion/update/deletion, and execution of complex queries.
Author: Anthropic
Stars: 7,800
GitHub
Install: npx -y @modelcontextprotocol/server-postgres postgresql://localhost/mydb
Key Features Execute SQL queries and retrieve results Automatic retrieval of table schema information Insert, update, and delete data operations Support for executing complex queries AI-assisted query generation and optimization
Use Cases Automate data analysis tasks — Have AI generate complex SQL queries to efficiently extract needed information from your database. Support application development — AI assists with table design and database schema creation to improve development efficiency. Data quality management — AI verifies database schema to prevent invalid operations while executing bulk updates safely.