Developer Tools
Database Management
Data Science & ML
DuckDB Server icon

DuckDB Server

Createdktanaka101

Enables interaction with a DuckDB database via the Model Context Protocol.

Github Repo

About

The DuckDB Server implements a Model Context Protocol (MCP) server, allowing Language Models (LLMs) to interact with a DuckDB database. It exposes a 'query' tool, which accepts any valid DuckDB SQL statement and returns the results or a success message. This allows for database operations such as querying, table creation, and schema inspection through MCP compatible tools. The server can also be run in read-only mode to prevent unintended data modification by the LLM.

Key Features

  • Executes SQL queries on a DuckDB database
  • Offers read-only mode to prevent write operations
  • 77 GitHub stars
  • Provides a unified 'query' tool for all database interactions
  • Supports database operations like querying, table creation, and schema inspection
  • Integrates with Claude Desktop via MCP configuration

Use Cases

  • Automating database tasks through LLM-based agents
  • Analyzing local datasets with LLMs
  • Building data-driven applications powered by LLMs