mcpdirectory.dev
9,129 servers · updated 23 Sept

Read Only Local Postgres MCP server

community Active last commit 19 d
{
  "mcpServers": {
    "hove-read-only-local-postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@hovecapital/read-only-postgres-mcp-server@latest"
      ],
      "env": {
        "DB_HOST": "<db_host>",
        "DB_DATABASE": "postgresql://user:password@host:5432/db",
        "DB_USERNAME": "<db_username>",
        "DB_PASSWORD": "<db_password>"
      }
    }
  }
}
file .mcp.json (in your project root)install npx -y @hovecapital/read-only-postgres-mcp-serverversion 0.1.0

What it does

An MCP server that allows Claude to execute read-only SQL queries against PostgreSQL databases. It connects to local or remote PostgreSQL instances and returns query results as JSON, with built-in statement validation and database-enforced read-only transactions.

  • Query database schema and table structure using natural language through Claude Desktop or Claude Code.
  • Retrieve data from PostgreSQL databases by describing what information you need in plain English.
  • Explore and analyze database contents without risk of modification, as all queries run in read-only mode.

Tools this server exposes

ToolDoes
queryExecute a read-only SQL query against the connected PostgreSQL database and receive results in JSON format.

Before you enable it

An MCP server runs with whatever access you give it. Start with a development account rather than production, and check which tools the server exposes before you let an agent call them unattended.