cratedb-mcp
Verified Safeby crate
Overview
CrateDB MCP Server enables natural-language Text-to-SQL and documentation retrieval for CrateDB database clusters, bridging AI assistants with database interaction.
Installation
uvx cratedb-mcp serveEnvironment Variables
- CRATEDB_CLUSTER_URL
Security Notes
The server implements SQL statement filtering (using `sqlparse`) to restrict database operations to SELECT queries by default, preventing DML/DDL. URL fetching for documentation and prompt fragments includes whitelisting for CrateDB/GitHub domains or robust HTTP error handling. Logging of HTTPX is configured to avoid revealing credentials. A critical risk exists with the `CRATEDB_MCP_PERMIT_ALL_STATEMENTS` environment variable; if set to true, it bypasses SQL filtering, allowing LLM agents to perform write/modify operations on the connected database. This override is explicitly warned about.
Similar Servers
context-portal
Manages structured project context for AI assistants and developer tools, enabling Retrieval Augmented Generation (RAG) and prompt caching within IDEs.
db-mcp-server
Provides AI assistants with structured access to multiple database systems (MySQL, PostgreSQL, SQLite, TimescaleDB) through the Model Context Protocol (MCP).
rust-docs-mcp
Provides AI agents with deep, cached access to Rust crate documentation, source code, and project structure for enhanced development.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.