PostgreSQL MCP Server

Example Use Cases

• 1

  List all tables in a PostgreSQL database.

• 2

  Detailed schema information about specific PostgreSQL tables.

• 3

  That require structured JSON responses for database schema and index data.

Description

This server connects to PostgreSQL databases and provides tools to list tables and retrieve detailed schema information including columns and indexes. It returns structured JSON responses optimized for AI model consumption, facilitating seamless integration and interaction with PostgreSQL databases. The server supports querying schema details such as column data types, nullability, default values, and index properties.