Advertise
MCP.so
Sign In

Simple PostgreSQL MCP Server

@NetanelBollag

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

NetanelBollag

About Simple PostgreSQL MCP Server

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.

Simple PostgreSQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "simple-psql-mcp": {
      "command": "uv",
      "args": [
        "venv"
      ]
    }
  }
}

Simple PostgreSQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Simple PostgreSQL MCP Server?

It is a template project for developers wanting to build their own MCP servers, designed to be dead simple to understand and adapt. It implements a PostgreSQL MCP server that provides tools, resources, and prompts, allowing LLMs to interact with a PostgreSQL database through natural language queries.

How to use Simple PostgreSQL MCP Server?

Prerequisites: Python 3.8+, uv, npx, and a PostgreSQL database. Set up a virtual environment, install dependencies, then run the server with the MCP Inspector using npx @modelcontextprotocol/inspector uv --directory . run postgres -e DSN=... -e SCHEMA=public. Alternatively, configure an AI assistant (e.g., Claude Desktop) with a JSON configuration file, or use the included generate_mcp_config.sh script. Once connected, ask the LLM questions in natural language about your data.

Key features of Simple PostgreSQL MCP Server

  • execute_query tool – run SQL queries against the database
  • test_connection tool – verify the database connection
  • Resources: db://tables, db://tables/{table_name}, db://schema
  • Prompts for query generation and analytical query building
  • Template structure for extending with custom MCP servers

Use cases of Simple PostgreSQL MCP Server

  • Query database tables and schema using natural language
  • Test database connectivity interactively
  • Explore schema information without writing raw SQL
  • Build and test custom MCP servers by following the template

Frequently asked questions

1

What prerequisites are needed?

Python 3.8+, uv (modern Python package manager), npx (included with Node.js), and a PostgreSQL database you can connect to.

2

How do I connect to my database?

Set the `DSN` (e.g., `postgresql://username:password@hostname:port/database`) and `SCHEMA` environment variables when running the inspector or in the MCP configuration file.

3

Is there an example database I can use?

Yes. Run the included script `./example-db/create-db.sh` to create a Docker container with a PostgreSQL database pre-populated with sample users and addresses tables.

4

Can I extend this server for other services?

Yes. Create a new directory under `/src`, implement your MCP server following the PostgreSQL example, and add your entry point to `pyproject.toml`. Then run it with `npx @modelcontextprotocol/inspector uv --directory . run your-mcp-name`.

5

Is this production-ready?

No. This is an experimental project; it only checks that the query starts with `SELECT`, making SQL injections easy. Do not run in production unless you are the founder and there are no paying clients.

Comments

More Databases MCP servers

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K
Advertise