Question 1

What dependencies are required?

Accepted Answer

Python 3 with the FastMCP package and other dependencies listed in `requirements.txt` (install via `pip install -r requirements.txt`).

Question 2

How is access to tables and columns controlled?

Accepted Answer

Access is configured in the `config.yaml` file, where you specify which tables are accessible, which columns are allowed for operations, and which operations (create, read, update, delete) are permitted per table.

Question 3

What transport mode does the server use?

Accepted Answer

The server runs in stdio mode, making it compatible with MCP clients that communicate over standard input and output.

Question 4

Is there a security risk with the execute_query tool?

Accepted Answer

Yes. The `execute_query` tool allows arbitrary SQL execution. The README advises considering restricting its use or implementing additional validation, as this could be a security risk if not carefully managed.

Question 5

How are database credentials stored?

Accepted Answer

Database credentials are stored in plain text in the `config.yaml` file. The README recommends using environment variables or a secure secret management solution in production.

PostgreSQL MCP Server

关于 PostgreSQL MCP Server