MCP PostgreSQL Server

A Model Context Protocol (MCP) server that provides tools for querying and inspecting a PostgreSQL database.

Features

• Execute Queries: Run standard SQL queries (SELECT, INSERT, UPDATE, etc.)

• List Schemas: View available schemas in the database

• List Tables: See tables within a specific schema

• Describe Tables: Get detailed column information for any table

Related MCP server: agr_postgres_mcp

Prerequisites

• Python 3.8+

• PostgreSQL database

• pip (Python package installer)

Setup

1. Clone the repository (if not already done)

2. Install dependencies:

   pip install -r requirements.txt

3. Configure Environment:

   • Copy .env.example to .env:

     cp .env.example .env  # On Windows: copy .env.example .env

   • Edit .env and fill in your PostgreSQL credentials:

     DB_HOST=localhost
     DB_PORT=5432
     DB_NAME=your_database
     DB_USER=your_username
     DB_PASSWORD=your_password

Usage

Running Locally

To run the server locally for testing:

python server.py

Testing Connection

You can verify your database connection configuration using the included test script:

python test_connection.py

Integrating with MCP Client (e.g., Claude Desktop, IDEs)

Add the server configuration to your MCP client settings:

{
  "mcpServers": {
    "postgres": {
      "command": "python",
      "args": ["/path/to/mcp-postgres-simple/server.py"]
    }
  }
}

Tools Available

• execute_query(query: str): Execute a SQL query

• list_schemas(): List all non-system schemas

• list_tables(schema: str = None): List tables in database or specific schema

• describe_table(table_name: str, schema: str = 'public'): Get column details for a table

License

MIT