1. Conduid
  2. Data
  3. Easy Postgres MCP
MCP server · Data

Easy Postgres MCP

by · github.com/perrypixel/Easy-Postgres-MCP

Minimal MCP server for PostgreSQL. Easily execute SQL queries with configurable read-only or write access, simple setup, and structured results—ideal for integrating PostgreSQL with MCP-compatible tool

Unclaimed last commit a year ago data
InstallView source
46Fair

Scored 5 months ago · breakdown

About Easy Postgres MCP

Easy Postgres MCP is an MCP server published by perrypixel in the Data category: minimal MCP server for PostgreSQL. Easily execute SQL queries with configurable read-only or write access, simple setup, and structured results—ideal for integrating PostgreSQL with MCP-compatible tool.

The repository has 13 stars and 4 forks, with the last commit a year ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues before depending on it in production.

Install

From source
git clone https://github.com/perrypixel/Easy-Postgres-MCP

This server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.

Ask AI

✦

Ask AI about Easy Postgres MCP

Powered by Claude · Grounded in docs

I know everything about Easy Postgres MCP. Ask me about installation, configuration, usage, or troubleshooting.

Security checks

Static checks derived from the repository yesterday. Heuristics on the source, not an audit.

  • ✓README presentThe repository ships documentation.
  • !License declaredNo license file. Legally you have no right to use it in a product.
  • !Tests presentNo tests found. Behaviour changes may go unnoticed between versions.
  • ✓Dependencies pinnedA lockfile pins dependency versions.
  • ✓No dynamic code executionSource scan found no eval, dynamic Function, or shell execution.
  • !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.

README

Simple PostgreSQL MCP Server

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

Features

  • 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

Getting Started

  1. Clone the repository 
    git clone https://github.com/perrypixel/Simple-Postgres-MCP
cd Simple-Postgres-MCP
  2. Install dependencies 
    npm install
  3. Build the project 
    npm run build

MCP Configuration

Add the following to your MCP client configuration (mcp.json):

Write Mode (default)

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

Read-Only Mode

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

Note: Update the path in the configuration to point to the index.js file inside your build folder.

Usage

  1. Copy the appropriate MCP configuration (read-only or write mode) to your tool’s mcp.json (e.g., Cursor, Windsurf, Copilot, etc.).
  2. Start your MCP client. The server is now ready to use!

Support

If you find this tool helpful, you can support the development by:

README fetched from the repository yesterday. The original is authoritative.

Questions

About Easy Postgres MCP

How do I install Easy Postgres MCP?

No package has been published for this server, so install it from source: clone the repository and follow its README.

Is Easy Postgres MCP safe to use with an AI agent?

Its trust score is 46 out of 100 (fair). It passes 3 of the 6 static security checks run so far; the failures are listed above. It has no ConduID identity yet, so agent calls to it are not receipted.

Is Easy Postgres MCP still maintained?

The last commit was a year ago. That's long enough that you should check whether the maintainer is responding to issues before depending on it.