Skip to main content
Glama
MCP Postgres Server

MCP Postgres Server

by MadeByNando

MCP Postgres Server

This server implements the Model Context Protocol (MCP) for Cursor, allowing a PostgreSQL database to be used as storage for model contexts.

Prerequisites

  • Docker

  • Docker Compose

Related MCP server: pg-mcp-server

Installation and startup

  1. Clone this repository

  2. Start the server with Docker Compose:

docker-compose up -d

Configuration in Cursor

  1. Open Cursor

  2. Go to Settings > MCP

  3. Add a new connection with the following settings:

    • Name: MCP Postgres Server

    • Type: command

    • Command: docker exec -i mcp-postgres-server node dist/index.js

Troubleshooting

If the server does not start correctly:

  1. Check the container logs:

    docker logs mcp-postgres-server
  2. To restart the server:

    docker-compose restart

MCP Server Features

The MCP PostgreSQL server exposes the following tools for Cursor:

  1. postgres_query - Execute a read-only SQL query

  2. postgres_list_tables - List all tables in the database

  3. postgres_describe_table - Get the schema of a specific table

These tools allow Cursor to securely explore and query the database.

Available Tools

10 tools
describe_tableC

Get the structure of a database table

Inputs: schema (required), table (required).

explain_queryC

Get query execution plan (EXPLAIN)

Inputs: sql (required), analyze, buffers, costs, +1 more.

get_constraintsC

Get constraints for a table

Inputs: schema (required), table (required).

get_table_statsC

Get table statistics and size information

Inputs: schema (required), table.

list_functionsC

List functions and procedures in a schema

Inputs: schema.

list_indexesC

List indexes for a table or schema

Inputs: schema (required), table.

list_schemasC

List all schemas in the database

Inputs: includeSystemSchemas.

list_tablesC

List all tables in a schema

Inputs: schema.

list_viewsC

List views in a schema

Inputs: schema.

queryA

Execute SQL queries with pagination support and parameterization for security. Supports page sizes up to 500 rows.

Inputs: sql (required), offset, pageSize, parameters.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.4/5.0

    Scored across 10 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose targeting specific database metadata or operations, with no overlap. For example, list_tables enumerates tables, describe_table provides table structure, and query executes SQL, making them easily distinguishable.

    Naming Consistency5/5

    All tools follow a consistent verb_noun pattern using snake_case, such as list_tables, describe_table, and get_constraints. This uniformity makes the tool set predictable and easy to navigate.

    Tool Count5/5

    With 10 tools, the server is well-scoped for database introspection and querying, covering essential metadata operations without being overwhelming. Each tool serves a clear, necessary function in the domain.

    Completeness4/5

    The tool set provides comprehensive coverage for database metadata exploration and query execution, including listing, describing, and analyzing tables, schemas, and functions. A minor gap is the lack of tools for modifying database structures (e.g., creating or altering tables), but core read operations are complete.

    Maintenance

    ActivityInactive
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server implementation that provides a simple interface to interact with PostgreSQL databases, enabling SQL queries, database operations, and schema management through MCP.
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server for PostgreSQL databases that enables AI agents to connect, query, and explore multiple databases with schema discovery and extension context.
      542
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      A standardized Model Context Protocol server for interacting with PostgreSQL databases, enabling full CRUD operations, schema management, and database introspection.
      1
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      MCP server for PostgreSQL that enables Cursor and other MCP clients to execute SQL queries, list tables, and explore database schemas via HTTP.
      1,408 npm
      MIT