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.

数据库分类下的更多 MCP 服务器

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s