Frequently Asked Questions about CockroachDB MCP Server

Q: What is an MCP Server? A: MCP (Model Context Protocol) is an open protocol for standardizing how applications provide context to LLMs. The MCP server acts as a bridge, allowing AI models to access and interact with external data sources like CockroachDB.

Q: How does the CockroachDB MCP Server work? A: It connects to your CockroachDB database and provides an interface for AI agents to execute SQL queries, retrieve table schemas, and monitor database status.

Q: What are the benefits of using the CockroachDB MCP Server? A: It simplifies integration between AI agents and CockroachDB, enables real-time data access, automates data-driven tasks, and improves decision-making.

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, and build custom AI Agents with your LLM model and Multi-Agent Systems.

Q: How does the CockroachDB MCP Server work with UBOS? A: It seamlessly integrates with the UBOS platform, enabling AI agents within UBOS to access and utilize CockroachDB data for various tasks.

Q: How do I install the CockroachDB MCP Server? A: You can install it automatically via Smithery or manually by cloning the repository and installing the dependencies.

Q: What parameters are required to connect to the database? A: You need the JDBC URL, username, and password for your CockroachDB database.

Q: How do I troubleshoot connection issues? A: Check the logs/cockroachdb_mcp.log file for detailed logs and ensure your CockroachDB server is running correctly and accessible.

Q: What special character handling is implemented? A: The server uses psycopg2 to automatically handle special characters in usernames and passwords.

Q: What are the TCP keep-alive settings? A: The server is configured with TCP keep-alive to prevent connection timeouts: keepalives=1, keepalives_idle=30, keepalives_interval=10, keepalives_count=5.