Simple Psql MCP

Name: Simple Psql MCP
Author: NetanelBollag

by NetanelBollag

A beginner-friendly MCP server template featuring a PostgreSQL connector with clean, easy-to-understand code. Perfect for developers new to Model Context Protocol who want to experiment and create their own AI tool connectors with minimal setup.

32 2 tools GitHub

No known CVEs

MIT license

Stale

Last commit 511d ago

Works with most clients

Transport: stdio, sse

2 tools · ~102 tok

Grade A · 0.1% of 200K ctx

MCPpedia last refreshed this data 1d ago

Edit this pageView history

Simple Psql MCP is an MCP server that a beginner-friendly MCP server template featuring a PostgreSQL connector with clean, easy-to-understand code. Perfect for developers new to Model Context Protocol who want to experiment and create their own AI tool connectors with minimal setup. Its tool list has not been published yet over stdio and sse, requires no API key, and scores 63/100 on MCPpedia's security, maintenance and efficiency rubric.

Data

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Supported in Claude Desktopstdio, sse · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgres": {
      "env": {
        "DSN": "postgresql://username:password@localhost:5432/my-db",
        "SCHEMA": "public"
      },
      "args": [
        "--directory",
        "/path/to/simple-psql-mcp",
        "run",
        "postgres"
      ],
      "command": "/path/to/uv"
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/simple-psql-mcp)](https://mcppedia.org/s/simple-psql-mcp)

Read me

What Simple Psql Mcp does

This is a template project for those looking to build their own MCP servers. I designed it to be dead simple to understand and adapt - the code is straightforward with MCP docs attached so you can quickly get up to speed.

Test This Server

No automated test available for this server. Check the GitHub README for setup instructions.

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

63/100across 5 weighted dimensions

How we score →

0255075100

−37

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

No package registry to scan.

Inventory

Tools (2)

Click any tool to inspect its schema.

~102 tokens total

Inventory

Resources (3)

db://tables

List of all tables in the schema

db://tables

db://tables/{table_name}

Schema information for a specific table

db://tables/{table_name}

db://schema

Complete schema information for all tables in the database

db://schema

Inventory

Prompts (2)

Query generation templates

Templates for generating SQL queries

Analytical query builders

Templates for building analytical queries

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is Simple Psql Mcp safe to use?: Simple Psql Mcp has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under MIT.
How do I install Simple Psql Mcp?: Simple Psql Mcp supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.
What can Simple Psql Mcp do?: Simple Psql Mcp provides 2 tools: execute_query, test_connection. See the full tools list on the server page for descriptions and parameters.
What AI clients work with Simple Psql Mcp?: Simple Psql Mcp is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse transport.
Is Simple Psql Mcp actively maintained?: Simple Psql Mcp is not actively maintained — last commit was 511 days ago. It has 32 GitHub stars.

Similar servers

Others in data

View all →

Supabase MCP Server96

Manage Supabase projects — databases, auth, storage, and edge functions

2.9k 4

Dbhub96

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.4k 2

Firecrawl Mcp Server95

🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.

7.3k 4

Mcp Server Typescript95

DataForSEO API modelcontextprotocol server

242 9

MCP Security Weekly

Get CVE alerts and security updates for Simple Psql Mcp and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

{ "mcpServers": { "postgres": { "env": { "DSN": "postgresql://username:password@localhost:5432/my-db", "SCHEMA": "public" }, "args": [ "--directory", "/path/to/simple-psql-mcp", "run", "postgres" ], "command": "/path/to/uv" } } }

Frequently Asked Questions

Is Simple Psql Mcp safe to use?

Simple Psql Mcp has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under MIT.

How do I install Simple Psql Mcp?

Simple Psql Mcp supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.

What can Simple Psql Mcp do?

Simple Psql Mcp provides 2 tools: execute_query, test_connection. See the full tools list on the server page for descriptions and parameters.

What AI clients work with Simple Psql Mcp?

Simple Psql Mcp is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse transport.

Is Simple Psql Mcp actively maintained?

Simple Psql Mcp is not actively maintained — last commit was 511 days ago. It has 32 GitHub stars.