How do I configure the database connection?

Set environment variables: `DB_HOST`, `DB_PORT`, `DB_USER`, `DB_PASSWORD`, and `DB_NAME`. Default values are provided in `.env.example`.

Can I execute any SQL query?

Only SELECT queries are allowed via the `query_database` tool; no modifications are supported.

What credentials does it need?

It reads `APP_NAME`, `DB_HOST`, `DB_PORT`, `DB_USER`, `DB_PASSWORD`, `DB_NAME` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

MCP PostgreSQL Demo MCP Server

Postgres MCP server

Local serverstdioPython

What is the MCP PostgreSQL Demo MCP Server?

Postgres MCP server

What it actually does

A FastMCP server that enables LLMs to connect and interact with PostgreSQL databases. This project demonstrates how to use the Model Context Protocol (MCP) to allow Language Models to query and explore database schemas and tables.

Schema Exploration — Retrieve metadata about database schemas
Table Inspection — Get detailed information about table structures
Database Querying — Execute SQL queries against the database
YAML Formatting — Results are returned in YAML format for easy consumption by LLMs

Configuration

Python 3.12 or higher - PostgreSQL database - UV package manager (recommended)

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
query_database	Execute SQL queries against the database (SELECT queries only)

How to install the MCP PostgreSQL Demo MCP Server

{
  "mcpServers": {
    "postgres-mcp-server": {
      "command": "/path/to/your/venv/bin/mcp",
      "args": ["run", "/path/to/your/postgres-mcp/src/main.py"],
      "env": {
        "APP_NAME": "mcp-demo",
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_USER": "postgres",
        "DB_PASSWORD": "postgres",
        "DB_NAME": "postgres"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

Python 3.12 or higher - PostgreSQL database - UV package manager (recommended)

Variable	Description	Required
APP_NAME	Configuration value read at startup.	Optional
DB_HOST	Endpoint or connection string the server talks to.	Optional
DB_PORT	Configuration value read at startup.	Optional
DB_USER	Configuration value read at startup.	Optional
DB_PASSWORD	Configuration value read at startup.	Optional
DB_NAME	Configuration value read at startup.	Optional