广告合作
MCP.so
登录

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

常见问题

1

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).

2

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.

3

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.

4

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.

5

Is SSL/TLS supported for database connections?

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

评论

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

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

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

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.

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

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

广告合作