Frequently Asked Questions (FAQ) - UBOS MCP Postgres Query Server

Q: What is the Model Context Protocol (MCP)?

A: MCP is an open protocol that standardizes how applications provide context to Large Language Models (LLMs). It acts as a bridge, enabling AI models to access and interact with external data sources and tools in a consistent manner.

Q: What does the UBOS MCP Postgres Query Server do?

A: This server allows AI models, like those used in Claude Desktop, to securely query PostgreSQL databases. It provides read-only access, query validation, and timeout protection to safeguard your data.

Q: Is the MCP Postgres Query Server secure?

A: Yes, security is a top priority. The server enforces read-only access, validates queries to prevent harmful operations, uses SSL encryption for database connections, and has timeout protection to prevent resource exhaustion.

Q: What kind of SQL queries can be executed through the MCP Postgres Query Server?

A: Only SELECT queries are permitted. The server strictly enforces read-only access to prevent any modifications to your database.

Q: How do I connect the MCP Postgres Query Server to Claude Desktop?

A: You need to modify the Claude Desktop configuration file (claude_desktop_config.json) to add an entry for the postgres-query-server, specifying the command and arguments, including the PostgreSQL connection string.

Q: What happens if a query takes too long to execute?

A: The server has timeout protection. Queries running longer than 10 seconds (by default) are automatically terminated to prevent resource exhaustion.

Q: What format are the query results returned in?

A: Query results are returned in a structured JSON format, making it easy for AI models to parse and process the data.

Q: Can I customize the query validation logic?

A: Yes, you can modify the isReadOnlyQuery() function to enforce more specific query validation rules.

Q: Where do I find the code for the MCP Postgres Query Server?

A: The main server implementation is in src/index.ts. You can find the project on GitHub (link in the description).

Q: What is UBOS?

A: UBOS is a full-stack AI Agent Development Platform that helps you orchestrate AI Agents, connect them with your enterprise data, build custom AI Agents with your LLM model and Multi-Agent Systems. Our platform is designed to bring AI Agent capabilities to every business department.