広告掲載
MCP.so
ログイン

Simple PostgreSQL MCP Server

@NetanelBollag

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

NetanelBollag

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 の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

Simple PostgreSQL MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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

よくある質問

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.

コメント

「データベース」の他のコンテンツ

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

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

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

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

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
広告掲載