Skip to main content
Glama
PostgreSQL MCP Server

PostgreSQL MCP Server

PostgreSQL MCP Server (Agent-Architected)

A high-performance Model Context Protocol (MCP) server built through recursive agentic development. This server provides Claude and other MCP clients with secure, direct access to PostgreSQL databases.

The "Meta" Development Story

This project was not manually coded in the traditional sense. It was "given birth" by utilizing a Windows MCP Server as an autonomous developer.

By acting as the Lead Architect, I provided high-level technical requirements and structural logic to the Windows MCP agent, which then autonomously:

  1. Generated the Node.js environment and dependency tree.

  2. Implemented the PostgreSQL connection pooling logic.

  3. Architected the MCP tool definitions for database interaction.

  4. Refined and debugged the syntax to produce a production-ready server.

This demonstrates a shift from manual implementation to Agentic Orchestration.

Key Features

  • ** Smart Query Execution:** Run optimized SELECT queries directly through the LLM interface.

  • ** Data Modification:** Execute INSERT, UPDATE, and DELETE statements safely.

  • ** Schema Exploration:** Instantly list tables and inspect complex structures/constraints.

  • ** Connection Pooling:** Robust management via high-performance pooling for efficiency.

  • ** Seamless Config:** Quick-start setup using environment variables and .env support.

Integration with Claude Desktop

To empower Claude with database access, add this server to your configuration file:

  • Windows: %APPDATA%\Claude\claude_desktop_config.json

  • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["/absolute/path/to/src/index.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "your_database",
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password"
      }
    }
  }
}

Tool Schema Changelog

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

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      B
      maintenance
      Enables secure read-only access to PostgreSQL databases, allowing users to list tables, query schemas, execute SELECT statements, and inspect table structures through natural language interactions.
      432 npm
      4
      MIT
    • A
      license
      B
      quality
      D
      maintenance
      Enables comprehensive PostgreSQL database management including index tuning, query plan analysis, health monitoring, schema-aware SQL generation, and safe SQL execution with configurable access control for both development and production environments.
      9
      MIT
    • A
      license
      B
      quality
      D
      maintenance
      Enables interaction with PostgreSQL databases through comprehensive database management tools including index tuning, query execution plans, health checks, schema intelligence, and safe SQL execution with configurable read-only mode for production use.
      35
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables safe interaction with PostgreSQL databases through read-only queries, schema exploration, and performance analysis.
      123 npm
      MIT