v2.3.0 — DuckDB engine bump for R duckdb 1.5.2 read compat

Install

Claude Desktop (One-Click)

Download che-duckdb-mcp.mcpb below and double-click to install.

Claude Code (CLI)

curl -L https://github.com/PsychQuant/che-duckdb-mcp/releases/download/v2.3.0/CheDuckDBMCP -o ~/bin/CheDuckDBMCP
chmod +x ~/bin/CheDuckDBMCP
claude mcp add --scope user --transport stdio che-duckdb-mcp -- ~/bin/CheDuckDBMCP

---

What's Changed (v2.3.0)

Changed

• Embedded DuckDB engine bumped from v1.5.0-dev8547 (revision d90cf8d) to v1.6.0-dev3343 (revision 4d9fb7c) so the MCP can read .duckdb files written by the R duckdb package v1.5.2 (the ai_martech pipeline writer). DuckDB storage is forward-incompatible — the embedded engine must track the writer. Fixes #2.
• swiftBindingRevision (reported by db_info) updated to 4d9fb7c.

Build

• Added a Developer ID sign + notarize pipeline (scripts/sign-and-notarize.sh); this release binary is signed + notarized (Team 6W377FS7BS), hardened runtime, spctl-verified as "Notarized Developer ID".

Notes

• duckdb-swift has no stable v1.5.2 tag (tags jump v1.5.0-dev* → v1.6.0-dev*). The originally-targeted v1.6.0-dev6343 does not compile with the current toolchain (Apple clang 21 / macOS 26 SDK): that tag amalgamates the vendored ICU extension into unity-build files where utmscale.cpp's #define milliseconds/seconds/... (no #undef) leak into timezone.h/simpletz.h parameter names → 9 compile errors. v1.6.0-dev3343 is the same v1.6.0-dev engine line (still newer than 1.5.2, so it reads 1.5.2 storage), compiles ICU per-file, and builds + verifies cleanly.
• Verified: built universal binary reports engine v1.6.0-dev3343; opens R-duckdb-1.5.2 DBs read-only (default format, storage_compatibility_version=latest, and a real pipeline app_data.duckdb) and returns rows — no "Storage version mismatch".
• Forward-compat reminder: the embedded engine must track whatever writer produces the DBs it reads.

v2.2.0 — First GitHub release of 2.x line

Summary

First GitHub release of the 2.x line. Includes all the 2.0.0 refactor work that previously only existed as local builds, plus the error-message fix from #1.

Install

curl -fsSL https://github.com/PsychQuant/che-duckdb-mcp/releases/latest/download/CheDuckDBMCP -o $HOME/bin/CheDuckDBMCP
chmod +x $HOME/bin/CheDuckDBMCP

Or install via Claude Code plugin (auto-downloads):

/plugin install che-duckdb-mcp@psychquant-claude-plugins

Added (2.0.0 carryover)

• TF-IDF inverted index search engine with cosine similarity scoring
• Fuzzy matching for function names (Levenshtein distance ≤ 2, case/underscore-insensitive)
• Multi-source documentation: llms.txt (3KB LLM reference) + duckdb-docs.md (5MB full docs)
• Conditional HTTP caching with ETag/Last-Modified
• Storage format version detection for .duckdb files
• Graceful storageVersionMismatch error with upgrade suggestions
• swiftBindingRevision field in db_info response

Fixed (#1)

• db_query / db_execute / db_connect / db_list_tables / db_describe now surface DuckDB's actual error messages (Binder Error, Catalog Error, Parser Error, etc.) instead of opaque DuckDB.DatabaseError error N strings.

Changed

• duckdb-swift pinned to commit d90cf8d (DuckDB v1.5.0-dev)
• MCP Swift SDK upgraded to 0.12.0 (Swift 6 concurrency)
• mcpb/manifest.json version synced to 2.2.0

Requirements

• macOS 13+ (arm64)

v1.1.0 - DuckDB Engine Upgrade

Install

Claude Desktop (One-Click)

Download che-duckdb-mcp.mcpb below and double-click to install.

Claude Code (CLI)

curl -L https://github.com/kiki830621/che-duckdb-mcp/releases/download/v1.1.0/CheDuckDBMCP -o ~/bin/CheDuckDBMCP
chmod +x ~/bin/CheDuckDBMCP
claude mcp add --scope user --transport stdio che-duckdb-mcp -- ~/bin/CheDuckDBMCP

---

Changed

• Upgrade DuckDB engine from v1.1.3 to v1.5.0-dev (supports storage format v1.0 ~ v1.5)
• Upgrade MCP Swift SDK from 0.10.2 to 0.11.0
• Switch duckdb-swift dependency to branch: "main" for latest engine

Fixed

• Fix DuckDB.DatabaseError error 5 when opening databases created with DuckDB v1.2+

v1.0.0 — Initial Release

Install

Claude Code (CLI)

curl -L https://github.com/kiki830621/che-duckdb-mcp/releases/download/v1.0.0/CheDuckDBMCP -o ~/bin/CheDuckDBMCP
chmod +x ~/bin/CheDuckDBMCP
claude mcp add --scope user --transport stdio che-duckdb-mcp -- ~/bin/CheDuckDBMCP

Or install via the che-duckdb-mcp Claude Code plugin (auto-downloads on first use).

---

[1.0.0] - 2025-01-19

Added

• Initial release combining documentation search and database operations
• Documentation Tools (8 tools): search_docs, list_sections, get_section, get_function_docs, list_functions, get_sql_syntax, refresh_docs, get_doc_info
• Database Tools (6 tools): db_connect, db_query, db_execute, db_list_tables, db_describe, db_info
• Support for JSON, Markdown, and CSV output formats
• Automatic documentation caching in temporary directory