PostgreSQL MCP Server

Example Use Cases

• 1

  Perform database queries and data manipulation on PostgreSQL databases.

• 2

  Manage database schemas and indexes programmatically.

• 3

  Analyze query performance and retrieve database statistics.

Description

This MCP server enables large language models and other tools to interact with PostgreSQL databases through a consistent protocol supporting full CRUD operations, schema management, introspection, and performance analysis. It offers configurable schema support, connection pooling, and type safety with TypeScript. Communication is done via JSON-RPC 2.0 over stdin/stdout, making it compatible with any MCP client.