v0.1.0 - DuckDB MCP Native
π Initial Release
Features
- π§ Full MCP Protocol Implementation: JSON-RPC 2.0 with stdio transport
- π DuckDB Integration: Query execution, table management, file loading
- π Security: SQL injection prevention, configurable security modes
- π¦ MCP Client Capabilities: Connect to external MCP servers
- π Virtual Tables: Map MCP resources to DuckDB tables
- πΎ Smart Caching: 5-minute TTL resource cache
- π οΈ Rich Toolset: 9+ MCP tools for comprehensive database control
MCP Tools
query_duckdb- Execute SQL queriescreate_table_from_json- Create tables from JSON dataread_parquet- Read Parquet filesread_csv- Import CSV filesexport_data- Export to various formatsmcpServe- Start MCP serversmcpAttach- Connect to external MCP serversmcpCreateVirtualTable- Map resources to virtual tablesmcpStatus- Get server/client status
Installation
npm install @deposium/duckdb-mcp-nativeQuick Start
# Start MCP server
npm run dev:server
# Test with MCP Inspector
npm run inspectorSee README.md for full documentation.
Full Changelog: https://github.com/theseedship/duckdb_mcp_node/commits/v0.1.0