crate/cratedb-mcp

3.4

If you are the rightful owner of cratedb-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The CrateDB MCP Server is an experimental feature that connects AI assistants to CrateDB clusters for natural-language Text-to-SQL and documentation retrieval.

Tools

Functions exposed to the LLM to take actions

get_health

Inquires about the health of the CrateDB cluster.

get_table_metadata

Retrieves metadata of tables in the CrateDB cluster.

query_sql

Executes SQL queries on the CrateDB cluster.

get_cratedb_documentation_index

Fetches the index of CrateDB documentation.

fetch_cratedb_docs

Retrieves specific CrateDB documentation.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

crate

Claim Ownership

Verify you have write access to the repository

Version

v0.0.7

Repository

https://github.com/crate/cratedb-mcp

Homepage

https://cratedb.com/docs/guide/integrate/mcp/cratedb-mcp.html

GitHub Stars

License

Apache License 2.0

Last publish date

2025-07-28

Last update date

2025-10-06

Server configs

in cursor

{
  "mcpServers": {
    "cratedb-mcp": {
      "command": "uvx",
      "args": ["cratedb-mcp", "serve"],
      "env": {
        "CRATEDB_CLUSTER_URL": "http://localhost:4200/",
        "CRATEDB_MCP_TRANSPORT": "stdio"
      },
      "alwaysAllow": [
        "get_health", 
        "get_table_metadata", 
        "query_sql", 
        "get_cratedb_documentation_index", 
        "fetch_cratedb_docs"
      ],
      "disabled": false
    }
  }
}

in vs code

{
  "mcp": {
    "servers": {
      "cratedb-mcp": {
        "command": "uvx",
        "args": ["cratedb-mcp", "serve"],
        "env": {
          "CRATEDB_CLUSTER_URL": "http://localhost:4200/",
          "CRATEDB_MCP_TRANSPORT": "stdio"
        }
      }
    }
  },
  "chat.mcp.enabled": true
}