Overview
what is MCP-SERVER-PG?
MCP-SERVER-PG is a Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
how to use MCP-SERVER-PG?
To use MCP-SERVER-PG, configure it with the Claude Desktop app or run it using Docker or NPX with the appropriate PostgreSQL connection string.
key features of MCP-SERVER-PG?
- Execute read-only SQL queries against connected PostgreSQL databases.
- Provides schema information for each table in JSON format.
- Automatically discovers table schemas from database metadata.
use cases of MCP-SERVER-PG?
- Inspecting database schemas for data analysis.
- Executing read-only queries for reporting purposes.
- Integrating with LLMs for enhanced data interaction.
FAQ from MCP-SERVER-PG?
- Can MCP-SERVER-PG modify data in the database?
No, MCP-SERVER-PG only allows read-only access to the database.
- How do I connect to my PostgreSQL database?
You can connect using a PostgreSQL URL format, including username and password if necessary.
- Is MCP-SERVER-PG free to use?
Yes, MCP-SERVER-PG is licensed under the MIT License, allowing free use and modification.