# 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