Model Context Protocol (MCP)¶
About
MCP, the Model Context Protocol, is an open protocol that enables seamless integration between LLM applications and external data sources and tools.
MCP is sometimes described as “OpenAPI for LLMs” or as “USB-C port for AI”, providing a uniform way to connect LLMs to resources they can use.
The main entities of MCP are Prompts, Resources, and Tools. MCP clients call MCP servers, either by invoking them as a subprocess and communicating via Standard Input/Output (stdio), Server-Sent Events (sse), or HTTP Streams (streamable-http), see transports.
Usage
You can use MCP with CrateDB and CrateDB Cloud, either by selecting the CrateDB MCP Server suitable for Text-to-SQL and documentation retrieval, or by using community MCP servers that are compatible with PostgreSQL databases.
The CrateDB MCP Server, available on PyPI and popular community hubs.
MCP servers mostly compatible with both PostgreSQL and CrateDB.
To use an MCP server, you need a client that supports the protocol. The most notable ones are ChatGPT, Claude, Cline, Cursor, GitHub Copilot, Mistral AI, OpenAI Agents SDK, VS Code, Windsurf, and others.
Discuss
To get in touch with us to discuss CrateDB and MCP, please head over to the CrateDB community forum at Introducing the CrateDB MCP Server.