AgentDank:

What is AgentDank?

AgentDank is a Model Context Protocol (MCP) server for querying cannabis datasets, built for educational and legal purposes. It is currently under refactor toward a generic, declarative dataset-binding architecture. The server opens DuckDB files in read-only mode and exposes a single SQL query tool.

How to use AgentDank?

Install via go install github.com/AgentDank/dank-mcp@latest or build from source with task. Configure your LLM host (e.g., Claude Desktop, Ollama with mcphost) to run the dank-mcp binary. Load a dataset with dank-mcp --fetch us/ct or point to any DuckDB file with --db. The server registers one tool query(sql) that returns CSV results.

Key features of AgentDank

• Single generic query MCP tool for SQL access
• Locked-down read-only DuckDB with external access disabled
• Automated dataset fetching, caching, and SHA-256 verification
• Declarative dataset bindings (in progress)
• Supports STDIO and SSE transports

Use cases of AgentDank

• Querying cannabis-specific datasets (e.g., Connecticut brands) for research or education
• Integrating with Claude Desktop for natural-language SQL queries
• Using local LLMs (e.g., Ollama) via mcphost for offline data exploration

FAQ from AgentDank

What cannabis datasets are currently available?

Today only the us/ct dataset is available, curated as a prebuilt DuckDB snapshot from the dank-data repository.

How do I load a dataset?

Run dank-mcp --fetch <id>, for example dank-mcp --fetch us/ct. The snapshot is downloaded, cached for 7 days, and verified before use.

Can I use my own DuckDB file?

Yes, point to any DuckDB file with the --db option (e.g., --db :memory: for in-memory). The file is opened read-only and locked down.

Is AgentDank production-ready?

No. The README states the server is under refactor and the integration with Ollama/mcphost is currently having issues. It is intended for educational and legal purposes.

How do I configure AgentDank with Claude Desktop?

Add a JSON configuration to your Claude Desktop mcpServers section specifying the command path to dank-mcp and arguments like --root ~. See the example in the README.