Skip to content

v0.6.0 - Virtual Filesystem with mcp:// protocol support

Choose a tag to compare

View all tags
@nicolas-geysse nicolas-geysse released this 21 Sep 17:46
v0.6.0
677a4e6

🚀 Virtual Filesystem v0.6.0

Major release introducing the Virtual Filesystem feature for transparent MCP resource access in DuckDB queries.

✨ Key Features

Virtual Filesystem

  • Direct SQL Access: Query MCP resources directly using mcp:// URIs in SQL
  • Transparent Resolution: Automatic translation of MCP URIs to local cached paths
  • Format Detection: Smart detection of CSV, JSON, Parquet, and other formats
  • Query Preprocessing: Seamless transformation without manual intervention

Example Usage

-- Query remote MCP resources as if they were local files
SELECT * FROM 'mcp://server-name/data.csv';
SELECT * FROM 'mcp://analytics/metrics.parquet' WHERE date > '2025-09-01';

🔧 Improvements

  • Resource Federation: Intelligent connection pooling and resource registry
  • Smart Caching: Efficient caching system for remote resources
  • Error Handling: Clear, actionable error messages for missing resources
  • STDIO Protocol: Fixed logging interference with MCP protocol

🐛 Bug Fixes

  • Eliminated STDIO interference by removing all logging from critical paths
  • Improved error messages for non-existent MCP resources
  • Reduced connection attempt spam for missing servers
  • Fixed JSON parsing errors in MCP communication

📦 Dependencies

  • @modelcontextprotocol/sdk upgraded for better stability
  • @duckdb/node-api optimized for virtual filesystem support

🔄 Version Alignment

This release aligns the version numbering across:

  • GitHub releases: v0.6.0
  • npm package: 0.6.0
  • Codebase features: Virtual Filesystem implementation

📝 Documentation

See the updated README.md for Virtual Filesystem configuration and usage examples.

Full Changelog: v0.3.1...v0.6.0

Assets 2
Loading