Postgresql MCP Server

@sarmadparvez

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

sarmadparvez

投稿者

Sarmad Parvez

Postgresql MCP Server について

A general-purpose PostgreSQL MCP server with full read-write support, atomic transactions, and schema inspection. Connect Claude, Cursor, Windsurf, or any MCP-compatible AI client to any PostgreSQL database — local, Supabase, AWS RDS, or self-hosted. No cloud lock-in, no Azure de

Postgresql MCP Server の設定

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

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@sarmadparvez/postgresql-mcp",
        "postgresql://user:pass@localhost:5432/mydb"
      ]
    }
  }
}

Postgresql MCP Server のツール

Execute a read-only SQL SELECT query and return results as JSON

Execute a write SQL statement (INSERT, UPDATE, DELETE, TRUNCATE, CREATE, DROP). Returns rows affected.

List all tables with their columns, types, and constraints for a given schema (default: public)

List all tables in the database with row counts

Execute multiple SQL statements as a single atomic transaction. Rolls back all on any error.

概要

What is Postgresql MCP?

Postgresql MCP is a general-purpose MCP server for PostgreSQL databases that provides full read-write support, atomic transactions, and schema inspection. It connects MCP-compatible AI clients such as Claude, Cursor, and Windsurf to any PostgreSQL database—local, Supabase, AWS RDS, or self-hosted—without cloud lock-in or Azure dependency.

How to use Postgresql MCP?

Configure the server by providing a connection string to your PostgreSQL database. An optional read-only mode can be enabled via a flag in the connection string. Once connected, you can execute SELECT, INSERT, UPDATE, DELETE, DDL statements, and multi-statement transactions with automatic rollback on failure.

Key features of Postgresql MCP

Full read-write support for PostgreSQL databases
Atomic transactions with automatic rollback
Schema inspection capabilities
Optional read-only mode via connection string flag
Supports SELECT, INSERT, UPDATE, DELETE, and DDL
Compatible with any MCP AI client (Claude, Cursor, Windsurf)

Use cases of Postgresql MCP

Allow AI assistants to run database queries and retrieve live data
Enable AI agents to perform schema analysis and table creation
Facilitate automated data entry and updates through natural language
Support safe read-only exploration of production databases

よくある質問

What database operations does Postgresql MCP support?

It supports SELECT, INSERT, UPDATE, DELETE, DDL statements, and multi-statement transactions with automatic rollback.

Can I use Postgresql MCP in read-only mode?

Yes, an optional read-only mode can be enabled via the connection string flag.

What kinds of PostgreSQL databases can I connect to?

Any PostgreSQL database—local instances, Supabase, AWS RDS, or self-hosted setups.

Is Postgresql MCP tied to any cloud provider?

No. It has no cloud lock-in and no dependency on Azure or any other provider.

Which AI clients are compatible with Postgresql MCP?

It works with any MCP-compatible AI client, including Claude, Cursor, and Windsurf.

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412