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.