PostgreSQL MCP Server

@habuvo

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

habuvo

PostgreSQL MCP Server について

MCP server to interact with and inspect PostgreSQL DB

PostgreSQL MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

PostgreSQL MCP Server のツール

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

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

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

概要

What is PostgreSQL MCP Server?

PostgreSQL MCP Server is a Model Context Protocol (MCP) server that provides a standardized API for interacting with PostgreSQL databases. It enables developers to execute queries, perform database operations, and manage transactions through MCP-compatible clients while using parameterized inputs for secure SQL execution.

How to use PostgreSQL MCP Server?

Clone the repository, install dependencies via go mod download, configure database credentials in a .env file, build with go build -o postgres-mcp, and run the server with ./postgres-mcp. The server exposes four MCP tools—execute_tool, query_tool, transaction_tool, and schema_tool—that accept JSON-formatted requests and return structured responses. A Go client example is provided in the README.

Key features of PostgreSQL MCP Server

Execute SQL queries with parameterized inputs
Perform database operations (INSERT, UPDATE, DELETE)
Execute transactions with multiple statements
Retrieve database schema information for tables
Secure parameter handling to prevent SQL injection

Use cases of PostgreSQL MCP Server

Running SELECT queries and returning result rows with column metadata
Inserting, updating, or deleting records via parameterized statements
Executing multiple statements atomically within a single transaction
Obtaining column names, data types, and nullability for a given table

よくある質問

What MCP tools does the server expose?

The server provides four tools: `execute_tool` (single SQL statement), `query_tool` (SELECT queries), `transaction_tool` (multi-statement transactions), and `schema_tool` (table schema).

How does the server prevent SQL injection?

All queries must use parameterized inputs (e.g., `$1`, `$2`) rather than concatenating user-provided values directly into SQL strings.

What are the runtime dependencies?

The server is written in Go and requires a PostgreSQL database. Database connection details are configured in a `.env` file using credentials provided by the user.

Can I run multiple statements in a single request?

Yes, the `transaction_tool` accepts an array of statements and executes them as an atomic transaction, returning results for each statement.

Is SSL/TLS supported for database connections?

Yes, the README recommends using SSL/TLS for database connections in production environments.

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

Postgres Mcp

crystaldba

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

3.0K

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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.