sushilparjapat/postgres-mcp-server

3.2

If you are the rightful owner of postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

Postgres MCP Pro is an open source Model Context Protocol (MCP) server designed to support AI agents throughout the development process, offering features like index tuning, explain plans, health checks, and safe SQL execution.

Tools

Functions exposed to the LLM to take actions

list_schemas

Lists all database schemas available in the PostgreSQL instance.

list_objects

Lists database objects within a specified schema.

get_object_details

Provides information about a specific database object.

execute_sql

Executes SQL statements on the database with read-only limitations in restricted mode.

explain_query

Gets the execution plan for a SQL query.

get_top_queries

Reports the slowest SQL queries based on execution time.

analyze_workload_indexes

Analyzes the database workload to recommend optimal indexes.

analyze_query_indexes

Analyzes specific SQL queries to recommend optimal indexes.

analyze_db_health

Performs comprehensive health checks on the database.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

sushilparjapat

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/sushilparjapat/postgres-mcp-server

License

MIT License

Last publish date

2025-06-16

Last update date

2025-06-16

Server configs

in claude desktop

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

via pip in claude desktop

{
  "mcpServers": {
    "postgres": {
      "command": "postgres-mcp",
      "args": [
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

in cursor

{
    "mcpServers": {
        "postgres": {
            "type": "sse",
            "url": "http://localhost:8000/sse"
        }
    }
}

in windsurf

{
    "mcpServers": {
        "postgres": {
            "type": "sse",
            "serverUrl": "http://localhost:8000/sse"
        }
    }
}