This DuckDB MCP server, developed by ktanaka101, provides a flexible interface for language models to interact with DuckDB databases. It enables AI agents to execute SQL queries, create tables, and inspect schemas through a controlled interface. The server can be run in read-only mode for enhanced security and integrates with Claude Desktop. By leveraging DuckDB's column-oriented architecture, it allows AI systems to efficiently analyze large datasets locally. This implementation is particularly useful for AI assistants designed to perform ad-hoc data analysis, generate insights from local files, or provide data-driven recommendations using DuckDB as a high-performance analytical database backend.
Execute any SQL query on the DuckDB database. Input: query (string) - Any valid DuckDB SQL statement. Output: Query results as text (or success message for operations like CREATE/INSERT).
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AI