Model Context Protocol (MCP)

Introduction

MCP, the Model Context Protocol, is an open protocol that enables seamless integration between LLM applications and external data sources and tools. 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), or by using Server-Sent Events (SSE), see Transports.

What’s Inside

The focus is on MCP servers for CrateDB that predominantly use PostgreSQL adapter implementations from the MCP ecosystem because CrateDB is compatible with PostgreSQL.

CrateDB MCP servers

Popular MCP servers that can connect to CrateDB.

What’s inside: An overview about MCP servers that are compatible with CrateDB.

CrateDB MCP servers

CrateDB MCP examples

Examples for all MCP servers compatible with CrateDB.

What’s inside: Ready-to-run MCP client programs written in Python.

CrateDB MCP exploration examples

Development

Walkthrough tutorial and API documentation to provide a few insights and starting points.

MCP sandbox tutorial

Learn how to get started invoking and inquiring MCP servers.

What’s inside: A complete walkthrough and guidelines for MCP and CrateDB.

CrateDB MCP sandbox walkthrough

API overview

An overview of a fragment of the MCP server landscape for PostgreSQL and CrateDB databases.

What’s inside: Detailed insights into exposed prompts, resources, and tools.

MCP server API details landscape for PostgreSQL and CrateDB