PostgreSQL MCP Server

@SwanHtetAungPhyo

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT license

トランスポート

stdio

作者

SwanHtetAungPhyo

PostgreSQL MCP Server について

概要はまだありません

#mcp #postgresql #golang #ai #database #model-context-protocol #sql#gorm#claude #assistant #server #api #data #query #secure #open-source

PostgreSQL MCP Server の設定

標準の設定はありません

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

リポジトリ

PostgreSQL MCP Server のツール

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

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

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

概要

What is PostgreSQL MCP Server?

PostgreSQL MCP Server is a Go-based MCP (Model Context Protocol) server that lets AI assistants interact with PostgreSQL databases through a standardized interface. It provides three main capabilities: executing SELECT queries, managing database schema with DDL, and modifying data with INSERT/UPDATE/DELETE — all with built-in security validation to prevent dangerous operations.

How to use PostgreSQL MCP Server?

Install by building the Go binary from source (requires Go 1.19+). Update the database connection string in main.go or use environment variables for credentials. Run the binary as a stdio transport server. Connect any MCP client (e.g., Claude Desktop) by adding the server to its configuration file, specifying the path to the binary. Use the three tools — execute_query, ddl_query, modify_query — for respective operations.

Key features of PostgreSQL MCP Server

Three validated SQL tools: query, DDL, and modify.
Blocks dangerous commands like TRUNCATE and GRANT.
Uses GORM for input sanitization and SQL injection protection.
Supports SSL for database connection security.
Compatible with all MCP clients using stdio transport.

Use cases of PostgreSQL MCP Server

Let an AI assistant answer business intelligence queries from a PostgreSQL database.
Enable AI to create and modify database tables for schema management.
Allow AI to insert, update, or delete records with validation.
Give AI read-only access to user analytics or inventory data.

よくある質問

How do I install the PostgreSQL MCP Server?

Create a Go project, add dependencies (`mcp-golang`, `gorm`, Postgres driver), copy the server code into `main.go`, update the connection string, then build and run the binary.

What types of database operations are supported?

Three operations: `execute_query` for SELECT queries, `ddl_query` for CREATE/ALTER/DROP statements, and `modify_query` for INSERT/UPDATE/DELETE commands.

How does PostgreSQL MCP Server ensure security?

Every query is validated before execution; only specific SQL types are allowed per tool. Commands like TRUNCATE and GRANT are blocked. All queries are sanitized through GORM's SQL injection protections.

How do I configure the database connection?

Set the connection string in the `dbConn` constant (e.g., `host=localhost user=postgres password=yourpassword dbname=yourdb port=5432 sslmode=require`) or read it from environment variables.

How do I connect PostgreSQL MCP Server to an MCP client like Claude Desktop?

Add an entry to the client’s configuration file (e.g., `claude_desktop_config.json`) with the `command` set to the path of the built binary. The server communicates over stdio.

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

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.