Name: CrateDB MCP Server
Author: crate

Question 1

What is the CrateDB MCP Server?

Accepted Answer

The CrateDB MCP Server is a tool that allows Large Language Models (LLMs) like Claude and ChatGPT to directly interact with your CrateDB database. It uses the Model Context Protocol (MCP) to provide context to the LLMs, enabling them to query data, retrieve documentation, and perform other tasks.

Question 2

What is MCP (Model Context Protocol)?

Accepted Answer

MCP is an open protocol that standardizes how applications provide context to LLMs. It allows LLMs to access and use external data sources and tools.

Question 3

What are the main use cases for the CrateDB MCP Server?

Accepted Answer

Some key use cases include:nn*   Translating natural language questions into SQL queries (Text-to-SQL).n*   Retrieving CrateDB documentation for accurate information.n*   Optimizing and debugging SQL queries.n*   Analyzing data and generating visualizations.n*   Understanding the current state of your database.

Question 4

How do I install the CrateDB MCP Server?

Accepted Answer

You can install it using `uv tool install`:  `uv tool install --upgrade git+https://github.com/crate/cratedb-mcp`

Question 5

How do I configure the CrateDB MCP Server?

Accepted Answer

You need to set the `CRATEDB_MCP_HTTP_URL` environment variable to point to your CrateDB instance (e.g., `http://localhost:4200/`).  You may also want to configure the `CRATEDB_MCP_DOCS_CACHE_TTL` for documentation caching.

Question 6

Which LLM clients are compatible with the CrateDB MCP Server?

Accepted Answer

Any LLM client that supports the Model Context Protocol (MCP) can be used.  Notable examples include Claude Desktop, ChatGPT desktop, OpenAI Agents SDK, and Cursor.

Question 7

Is it safe to allow LLMs to modify data in my CrateDB database?

Accepted Answer

It's generally not recommended to allow LLMs to directly insert or modify data. The CrateDB MCP Server defaults to only allowing `SELECT` statements for security reasons. Carefully consider the risks before enabling data modification capabilities.

Question 8

How does the CrateDB MCP Server improve query optimization?

Accepted Answer

The MCP server enables LLMs to access database statistics, execution plans, and CrateDB documentation. This allows the LLM to analyze queries and suggest improvements based on best practices and the specific characteristics of your data.

Question 9

What is the `CRATEDB_MCP_DOCS_CACHE_TTL` environment variable for?

Accepted Answer

It defines the cache lifetime (in seconds) for documentation resources.  The default value is 3600 seconds (1 hour).

Question 10

What transport options are supported by the CrateDB MCP Server?

Accepted Answer

The server supports both `stdio` and `sse` transport methods. You can specify the transport method using the `CRATEDB_MCP_TRANSPORT` environment variable.

Question 11

Can I use the CrateDB MCP Server with CrateDB Cloud?

Accepted Answer

Yes, you can.  Set the `CRATEDB_MCP_HTTP_URL` environment variable to the URL of your CrateDB Cloud instance, including the necessary credentials (e.g., `https://admin:dZ...6LqB@testdrive.eks1.eu-west-1.aws.cratedb.net:4200/`).

CrateDB MCP Server

Resources

Project Details

Recomended MCP Servers

Featured Templates

Pharmacy Admin Panel

Image to text with Claude 3

Service ERP

AI Chatbot Starter Kit

Multi-language AI Translator

AI-Powered Essay Outline Generator

Start your free trial