CrateDB MCP backlog

Iteration +1

• README: Provide guidelines on how to create a CrateDB read-only user

• CLI: Honor --read-only option flag

  • https://fluxcd.control-plane.io/mcp/config/

• Release v0.0.1

Iteration +2

• Migrate to FastAPI 2.0

  • https://gofastmcp.com/getting-started/welcome#fastmcp-2-0-and-the-official-mcp-sdk

  • https://gofastmcp.com/patterns/testing

• README: Provide AI assistant snippets about configuring sse or streamable-http transports, see Cline and LibreChat, by adding a section about how to connect to existing MCP servers via URL endpoints.

  • https://docs.cline.bot/mcp/connecting-to-a-remote-server

  • https://www.librechat.ai/docs/configuration/librechat_yaml/object_structure/mcp_servers

• Install: Others also just use docker right away? Others discourage using uvx.

  • https://github.com/ppl-ai/modelcontextprotocol/?tab=readme-ov-file#step-3-configure-claude-desktop

  • https://medium.com/@scalablecto/stop-running-your-mcp-tools-via-npx-uvx-right-now-380d1ab99d3f

• Ecosystem: Link to 3rd-party installation instructions?

  • https://code.visualstudio.com/docs/copilot/chat/mcp-servers#_add-an-mcp-server-to-your-workspace

  • https://docs.cline.bot/mcp/configuring-mcp-servers

  • https://docs.cline.bot/mcp/adding-mcp-servers-from-github

  • https://docs.cline.bot/mcp/connecting-to-a-remote-server

• Ecosystem: Interoperability with tools of other frameworks (OpenAI, OpenRouter, LangChain)

  • https://openrouter.ai/docs/use-cases/mcp-servers

• Ecosystem: Server Composition

  • https://gofastmcp.com/servers/fastmcp#composing-servers

  • https://gofastmcp.com/servers/composition

  • https://github.com/f/mcptools/pull/41

Iteration +3

• Provide “instructions”

  For the best experience with the CrateDB MCP Server, it’s crucial to provide your AI assistant with proper instructions on how to interact. […] The CrateDB MCP Server comes with a set of predefined instructions that you can copy from the instructions.md file.

  Blueprint:

  • https://fluxcd.io/blog/2025/05/ai-assisted-gitops/

  • https://fluxcd.control-plane.io/mcp/prompt-engineering/

  • https://raw.githubusercontent.com/controlplaneio-fluxcd/distribution/refs/heads/main/docs/mcp/instructions.md

• Docs: Load documentation index from a custom outline file

• Naming things: Better names for API entrypoints?

• Use platformdirs.user_cache_dir for Hishel, see pueblo.cache

• Refactoring

  • Extract SqlFilter or SqlGateway functionality to the cratedb-sqlparse package

  • Extract other utilities to the pueblo package

Done

• Make it work

• SQL: Stronger read-only mode

• Docs: HTTP caching

• Improve documentation

• Format code, improve linting

• Docs: About CRATEDB_MCP_HTTP_TIMEOUT

• Release v0.0.0

• CLI: For real. Blueprint: https://fluxcd.control-plane.io/mcp/config/

• Enable MCP transport streamable-http

• UX: Make streamable-http the default transport? => No.

• Docs:

  Claude, Cursor, and Windsurf vs. VS Code Copilot Chat – https://fluxcd.control-plane.io/mcp/install/#configuration-with-ai-assistants

• Docs:

  Once installed, you can configure your AI assistant to use the Flux MCP Server. For Claude, Cursor, Windsurf, or GitHub Copilot add the following configuration to the MCP settings. – https://fluxcd.io/blog/2025/05/ai-assisted-gitops/#getting-started

• Docs: Improve README. The Flux MCP Server and Operator are excellent blueprints. https://github.com/controlplaneio-fluxcd/flux-operator https://fluxcd.control-plane.io/mcp/

• UX: Improve documentation, generalizing a bit beyond Claude only

• README: Use FastMCP client instead of mcptools program? => No. There is no FastMCP client.

• README: What’s inside: Talk about “MCP tools”

• README: Add configuration snippets for Goose and LibreChat https://github.com/f/mcptools/issues/45

• mcptools: mcpt call does not exit with returncode != 0 when “Unknown tool:” happens https://github.com/f/mcptools/issues/53