Simple Postgres MCP Server

Simple MCP server for executing PostgreSQL queries

Local serverstdio

What is the Simple Postgres MCP Server?

Simple MCP server for executing PostgreSQL queries

The short version

A minimal Model Context Protocol (MCP) server for executing SQL queries on PostgreSQL databases with configurable permissions.

  • Execute SQL queries with optional read-only or write access
  • Server-level mode (read-only/write) configurable via command line
  • Returns structured results with metadata
  • Simple setup using a PostgreSQL connection string

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the Simple Postgres MCP Server

{
  "mcpServers": {
    "simple-postgresql-mcp": {
      "command": "node",
      "args": [
        "/path/to/build/index.js",
        "postgresql://username:password@localhost:5432/database_name",
        "write"
      ]
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Frequently asked questions

Simple MCP server for executing PostgreSQL queries Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.