Advertise
MCP.so
Sign In

MCP PostgreSQL Demo

@Tibiritabara

Repository

Basic information

Category

Databases

Transports

stdio

Author

Tibiritabara

About MCP PostgreSQL Demo

Postgres MCP server

MCP PostgreSQL Demo config

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

{
  "mcpServers": {
    "postgres-mcp-tibiritabara": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        ".venv"
      ]
    }
  }
}

MCP PostgreSQL Demo tools

1

Execute SQL queries against the database (SELECT queries only)

Overview

What is MCP PostgreSQL Demo?

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

How to use MCP PostgreSQL Demo?

Install Python 3.12+, PostgreSQL, and UV. Clone the repository, create a virtual environment, install dependencies with uv sync, and configure environment variables. Uncomment the run function in src/main.py and start the server with python -m src.main. Alternatively, use Docker with the provided Dockerfile. For client applications, add the MCP configuration to the client’s MCP config file (e.g., .cursor/mcp.json).

Key features of MCP PostgreSQL Demo

  • Schema Exploration: Retrieve metadata about database schemas
  • Table Inspection: Get detailed information about table structures
  • Database Querying: Execute SQL SELECT queries against the database
  • YAML Formatting: Results returned in YAML format for LLM consumption
  • Predefined prompts for schema, table descriptions, and data queries

Use cases of MCP PostgreSQL Demo

  • Allow LLMs to explore database schemas without direct SQL access
  • Enable LLMs to query table data using natural language via prompts
  • Provide structured metadata to LLMs for context-aware responses
  • Demonstrate MCP integration with PostgreSQL for AI assistants

Frequently asked questions

1

What are the prerequisites for running the server?

Python 3.12 or higher, a PostgreSQL database, and UV package manager (recommended).

2

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`.

3

Can I execute any SQL query?

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

4

How are query results formatted?

Results are returned in YAML format for easy parsing by LLMs.

5

Can I run this server in Docker?

Yes, build the image with `docker build -t mcp-demo .` and run with `docker run --env-file .env.docker -p 8000:8000 mcp-demo`.

Comments

More Databases MCP servers

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

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

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K
Advertise