PostgreSQL

Name: PostgreSQL
Author: vinsidious

@vinsidious

リポジトリ

PostgreSQL について

MCP server for getting schema information from a PostgreSQL database

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

基本情報

カテゴリ

データベース

ランタイム

node

トランスポート

stdio

公開者

vinsidious

設定

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

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

ツール

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.

FAQ from PostgreSQL

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.

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

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

MongoDB Lens

furey

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

204

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245