PostgreSQL MCP Server

@vinsidious

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

vinsidious

PostgreSQL MCP Server について

MCP server for getting schema information from a PostgreSQL database

#mcp-pg-schema#postgresql #database-access

PostgreSQL MCP Server の設定

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

{
  "mcpServers": {
    "mcp-pg-schema": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mcp/postgres",
        "-f",
        "src/postgres/Dockerfile",
        "."
      ]
    }
  }
}

PostgreSQL MCP Server のツール

Execute read-only SQL queries against the connected database

概要

What is PostgreSQL?

A Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries.

How to use PostgreSQL?

Configure the server in the claude_desktop_config.json under mcpServers using either Docker (run mcp/postgres image) or NPX (@modelcontextprotocol/server-postgres). Provide a PostgreSQL connection URL (e.g., postgresql://host.docker.internal:5432/mydb) as an argument.

Key features of PostgreSQL

Execute read-only SQL queries via the query tool.
Automatically discover and serve table schemas as JSON resources.
All queries run within a READ ONLY transaction.
Supports Docker and NPX deployment methods.
MIT licensed.

Use cases of PostgreSQL

Let an LLM explore table structures and column types before generating queries.
Allow an LLM to run safe, read-only SELECT statements against a live database.
Provide database schema context to an AI assistant for answering questions about data.

よくある質問

Is this server read-only?

Yes. All queries are executed inside a READ ONLY transaction, preventing any data modification.

What are the runtime requirements?

You need a running PostgreSQL database and either Docker or Node.js (for NPX). The server connects to the database via the provided URL.

How do I specify authentication credentials?

Include username and password in the PostgreSQL connection URL, e.g., `postgresql://user:password@host:port/db-name`.

Where does schema data come from?

Schema information is automatically discovered from the connected database's metadata. Each table's JSON schema includes column names and data types.

What transport does this server use?

The server follows the Model Context Protocol (stdio-based transport as typical for Claude Desktop MCP servers). The README does not detail other transport options.

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

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Xata MCP Server

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

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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