cratedb-mcp
Verified Safeby crate
Overview
The CrateDB MCP Server enables natural-language Text-to-SQL querying, cluster health monitoring, and documentation retrieval for CrateDB database clusters, acting as a bridge for AI assistants.
Installation
uvx cratedb-mcp serveEnvironment Variables
- CRATEDB_CLUSTER_URL
- CRATEDB_MCP_TRANSPORT
- CRATEDB_MCP_HOST
- CRATEDB_MCP_PORT
- CRATEDB_MCP_PATH
- CRATEDB_MCP_HTTP_TIMEOUT
- CRATEDB_MCP_DOCS_CACHE_TTL
- CRATEDB_MCP_PERMIT_ALL_STATEMENTS
- CRATEDB_MCP_INSTRUCTIONS
- CRATEDB_MCP_CONVENTIONS
Security Notes
The server enforces read-only SQL (DQL) by default, rejecting DDL/DML statements. It includes URL whitelisting for documentation fetching to prevent arbitrary external requests. A `CRATEDB_MCP_PERMIT_ALL_STATEMENTS` environment variable can bypass the read-only restriction, but it's explicitly warned against. Logging of HTTPX is tamed to avoid exposing credentials. The primary security risks stem from user configuration, such as pointing to an untrusted CrateDB cluster or using privileged database credentials with `CRATEDB_MCP_PERMIT_ALL_STATEMENTS` enabled.
Similar Servers
context-portal
A database-backed Model Context Protocol (MCP) server for managing structured project context, designed to be used by AI assistants and developer tools within IDEs and other interfaces for Retrieval Augmented Generation (RAG) and prompt caching.
db-mcp-server
Provides AI assistants with structured access to multiple databases, enabling them to execute SQL queries, manage transactions, explore schemas, and analyze performance through a unified interface.
rust-docs-mcp
Provides AI agents with deep, cached access to Rust crate documentation, source code, and project structure for enhanced development.
SchemaCrawler-AI
Enables AI agents to query and understand database schemas, facilitating natural language interaction and SQL generation.