Skip to main content
Glama
NeuroviaLabs

pg-mcp

by NeuroviaLabs
OverviewSchemaSourceRelated ServersDiscussionsAdmin
JavaScript
Remote

neurovia-labs-pg-mcp

A lightweight MCP server for read-only PostgreSQL access. Maintains a persistent connection pool and exposes query tools for use with Claude Code or any MCP client.

Tools

Tool

Description

query

Run a read-only SQL query (SELECT, WITH, EXPLAIN)

list_tables

List all tables in a schema

describe_table

Show columns and types for a table

Related MCP server: PostgreSQL MCP Server

Usage

With npx (no install)

Add to your .mcp.json:

{
  "mcpServers": {
    "db": {
      "command": "npx",
      "args": ["github:NeuroviaLabs/pg-mcp"],
      "env": {
        "DATABASE_URL": "postgresql://user:pass@host:5432/dbname"
      }
    }
  }
}

Local

git clone git@github.com:NeuroviaLabs/pg-mcp.git
cd pg-mcp
npm install

Add to your .mcp.json:

{
  "mcpServers": {
    "db": {
      "command": "node",
      "args": ["db-server.js"],
      "env": {
        "DATABASE_URL": "postgresql://user:pass@host:5432/dbname"
      }
    }
  }
}

The connection URL can also be passed as a CLI argument:

node db-server.js postgresql://user:pass@host:5432/dbname

Features

  • Persistent connection pool (max 5 connections)

  • Read-only enforcement (SELECT/WITH/EXPLAIN only + read-only transactions)

  • 30s query timeout

  • SSL support

License

ISC

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • PostgreSQL MCP Server

    hsinyuyen
    A
    license
    Not graded
    quality
    D
    maintenance
    Provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries.
    93,517 npm
    MIT

  • PostgreSQL MCP Server

    larturi
    A
    license
    Not graded
    quality
    D
    maintenance
    Provides read-only access to PostgreSQL databases, enabling users to list tables, view table structures and statistics, and execute SELECT queries safely through natural language.
    101 npm
    MIT

  • MCP PostgreSQL Server

    kristofer84
    A
    license
    Not graded
    quality
    C
    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.
    529 npm
    4
    MIT