广告合作
MCP.so
登录

MCP PostgreSQL Demo

@Tibiritabara

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

Tibiritabara

关于 MCP PostgreSQL Demo

Postgres MCP server

MCP PostgreSQL Demo 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

MCP PostgreSQL Demo 工具

1

Execute SQL queries against the database (SELECT queries only)

概览

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

常见问题

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

评论

数据库 分类下的更多 MCP 服务器

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

广告合作