Frequently Asked Questions about mcp-server-postgres

Q: What is mcp-server-postgres? A: mcp-server-postgres is a Model Context Protocol (MCP) server that allows Large Language Models (LLMs) to securely access and query PostgreSQL databases in a read-only manner.

Q: How does mcp-server-postgres ensure data security? A: It enforces read-only access, executing all queries within READ ONLY transactions. It is recommended to create a dedicated read-only user in your PostgreSQL database for enhanced security.

Q: What are the main features of mcp-server-postgres? A: Key features include read-only database access, schema inspection capabilities, Docker support, and an NPM package for easy integration.

Q: How do I install mcp-server-postgres? A: You can install it using Docker or via Smithery. Instructions for both methods are provided in the documentation.

Q: What is Smithery? A: Smithery is a tool that simplifies the installation and management of MCP servers.

Q: How do I configure Claude Desktop to use mcp-server-postgres? A: You need to add a configuration block to your claude_desktop_config.json file, specifying the command and arguments for running the mcp-server-postgres server.

Q: What is the connection URL format for PostgreSQL? A: The connection URL format is postgresql://[user][:password]@host[:port]/database, where you should replace /database with your database name.

Q: Can I use mcp-server-postgres with databases running on my host machine when using Docker on macOS? A: Yes, use host.docker.internal as the host in the connection URL if your PostgreSQL server is running on the host network.

Q: What kind of queries can LLMs execute through mcp-server-postgres? A: LLMs can only execute read-only queries. This means they can select data but cannot modify or delete any data.

Q: Is mcp-server-postgres open source? A: Yes, it is released under the MIT License.

Q: How can I contribute to mcp-server-postgres? A: Contributions are welcome! Feel free to submit a Pull Request.

Q: How does mcp-server-postgres integrate with the UBOS platform? A: mcp-server-postgres provides a secure way for AI Agents on the UBOS platform to access and utilize data stored in PostgreSQL databases. This allows UBOS users to build more sophisticated and data-driven AI applications.

Q: What if I have other databases besides Postgres? A: You can check if there are other MCP server options at https://smithery.ai/.