Postgres FAQs

Question 1

What are the main features?

Accepted Answer

Key features include exposing database schema information as JSON, enabling read-only SQL query execution, automatically discovering table schemas, using READ ONLY transactions, and supporting Docker and NPX deployment.

Question 2

How can I use it with Claude Desktop?

Accepted Answer

You can configure it within the 'mcpServers' section of your 'claude_desktop_config.json' file using either Docker or NPX, as shown in the documentation examples.

Question 3

Is it safe to use with my database?

Accepted Answer

Yes, it only allows read-only access to your database, ensuring that no data can be modified or deleted by the LLM.

Question 4

What does Postgres for LLMs do?

Accepted Answer

It provides a read-only interface to PostgreSQL databases, allowing Large Language Models (LLMs) to inspect schemas and execute SQL queries without modifying the database.

Question 5

What kind of queries can I execute?

Accepted Answer

You can execute any valid SQL `SELECT` query that retrieves data from your database. Data modification queries are not allowed.

Postgres

主要功能

使用案例

Postgres

主要功能

使用案例