Postgres FAQs

Question 1

Which SQL operations are allowed and which are blocked by pg-mcp?

Accepted Answer

Only `SELECT` and `WITH` queries are safely executed. Destructive SQL operations such as `INSERT`, `UPDATE`, `DELETE`, `DROP`, `TRUNCATE`, and `ALTER` are automatically blocked by default to prevent unintended changes.

Question 2

What is Postgres (pg-mcp) and what is its primary purpose?

Accepted Answer

Postgres (pg-mcp) is a Go-built MCP (Model Context Protocol) server designed to provide a safe, read-only interface for querying PostgreSQL databases. Its primary purpose is to ensure data integrity by blocking all destructive SQL operations.

Question 3

Does pg-mcp support different integration methods?

Accepted Answer

Yes, pg-mcp offers flexible transport modes: `stdio` for direct CLI or agent integrations, and `HTTP` for exposing the server as a service, making it versatile for various deployment scenarios.

Question 4

Is pg-mcp suitable for Docker environments?

Accepted Answer

Absolutely. pg-mcp is Docker-ready, providing pre-built images for both arm64 and amd64 architectures, simplifying deployment and ensuring consistent environments.

Question 5

How does pg-mcp handle errors during queries?

Accepted Answer

When queries fail, pg-mcp provides schema discovery capabilities, which can help in debugging and understanding the database structure related to the failed query.

Postgres

Características Principales

Casos de Uso

Postgres

Características Principales

Casos de Uso