広告掲載
MCP.so
ログイン

Postgres MCP Server

@freakynit

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

freakynit

投稿者

Nitin Bansal

Postgres MCP Server について

A lightweight MCP (Model Context Protocol) server built to query Postgres database. It provides comprehensive tools for database operations, table introspection, and query execution with smart permission handling.

#postgres#postgre#database#best

Postgres MCP Server の設定

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

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@freakynit/postgres-mcp@latest"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES HOST>",
        "POSTGRES_USER": "<POSTGRES USER>",
        "POSTGRES_PASSWORD": "<POSTGRES PASSWORD>",
        "POSTGRES_DATABASE": "<POSTGRES DATABASE>"
      }
    }
  }
}

Postgres MCP Server のツール

4

List all user tables in the database

Get comprehensive table information for one or more tables including columns, indexes, triggers, foreign keys, and constraints

Execute a SQL query. The system will automatically detect the required permission level and request user approval for write operations and dangerous DDL commands.

Switches the active database to the specified one. If an error occurs during the switch, the system automatically reverts back to the previous active database

概要

What is Postgres Mcp?

Postgres Mcp is a lightweight MCP (Model Context Protocol) server for querying a Postgres database using SQL or plain English commands. It provides tools for database operations, table introspection, and query execution with smart permission handling, intended for use with MCP-enabled AI assistants.

How to use Postgres Mcp?

Configure the server in an mcpServers JSON block with environment variables POSTGRES_HOST, POSTGRES_USER, POSTGRES_PASSWORD, and POSTGRES_DATABASE (and optionally POSTGRES_PORT, POSTGRES_SSL, etc.). On macOS/Linux use npx -y @freakynit/postgres-mcp@latest as the command; on Windows use cmd /k npx -y @freakynit/postgres-mcp@latest.

Key features of Postgres Mcp

  • Smart query permission handling (read-only, read-write, admin/DDL)
  • Dry-run mode to validate queries without execution
  • Comprehensive table introspection (columns, keys, indexes, triggers, constraints)
  • Multiple database switching capability
  • Robust error handling and rollback

Use cases of Postgres Mcp

  • Ask an AI assistant to list all tables and describe their schemas
  • Execute read-only queries (SELECT, EXPLAIN) with automatic approval
  • Run INSERT/UPDATE/DELETE queries after user confirmation
  • Switch between multiple Postgres databases in one session
  • Safely test SQL statements using dry-run mode

よくある質問

1

How does permission handling work?

Read-only queries (SELECT, EXPLAIN, SHOW, VALUES) are automatically approved. Read-write queries (INSERT, UPDATE, DELETE, MERGE) require user confirmation. Admin/DDL queries (CREATE, ALTER, DROP, etc.) require elevated permission.

2

Can I run a query without actually executing it?

Yes, dry-run mode lets you validate queries without execution.

3

What environment variables are needed?

Minimum four variables: `POSTGRES_HOST`, `POSTGRES_USER`, `POSTGRES_PASSWORD`, `POSTGRES_DATABASE`. Optionally set `POSTGRES_PORT`, `POSTGRES_SSL`, `POSTGRES_VERIFY`, `POSTGRES_SEND_RECEIVE_TIMEOUT`, and `POSTGRES_CONNECT_TIMEOUT`.

4

What tools does Postgres Mcp provide?

Four tools: `execute_raw_query`, `list_tables`, `describe_tables`, and `switch_database`.

5

Can I switch databases during a session?

Yes, the `switch_database` tool allows changing the active database connection.

コメント

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

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

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.

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

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

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K
広告掲載