duckdb-query

by Chenkeliang · Databases · ★ 48

duckdb-query is an MCP server by Chenkeliang. 基于 DuckDB 的 AI 可视化 SQL 工作台,本地文件与远程库一站式跨源分析。AI-native visual SQL workbench on DuckDB. Query local CSV/Excel/JSON + remote MySQL/Postgres together with text-to-SQL chat — no ETL, local-first, cross-source JOINs. DuckDB Desktop. It has 48 GitHub stars and ranks #230 of 630 in Databases by stars.

Category: Databases
Author: Chenkeliang
GitHub stars: 48
This week: Tracking since 22 Oct 2026
Language: TypeScript
License: MIT (open source)
Last update: 2026-10-20 (4 days ago)
Links: Source Website PyPI

duckdb
data-visualization
csv
excel
federated-query
mysql
text-to-sql
duckdb-ui
duckdb-desktop
duckdb-gui

How to install duckdb-query

duckdb-query is published on PyPI as duckquery-mcp, and it depends on mcp. These steps assume it runs as a local stdio server, which is the usual setup.

Check the README. Confirm the start command and note any API keys or environment variables it needs (pass them with -e KEY=value or an env block). You need uv for uvx.

Add it to Claude Code from a terminal:

claude mcp add duckdb-query -- uvx duckquery-mcp

Or add it to Cursor or Claude Desktop in .cursor/mcp.json or claude_desktop_config.json:

{
  "mcpServers": {
    "duckdb-query": {
      "command": "uvx",
      "args": [
        "duckquery-mcp"
      ]
    }
  }
}

Restart the client and check it. Run claude mcp list, or open the client's MCP settings, and confirm duckdb-query and its tools are listed. The install guide covers VS Code and Codex.

Also listed in

Maintain this project? Get it featured ($99/mo, pinned at the top of Databases) or see what featuring includes.

Report a problem with this listing

Frequently asked questions

What is duckdb-query?

duckdb-query is an MCP server by Chenkeliang in the Databases category. 基于 DuckDB 的 AI 可视化 SQL 工作台,本地文件与远程库一站式跨源分析。AI-native visual SQL workbench on DuckDB. Query local CSV/Excel/JSON + remote MySQL/Postgres together with text-to-SQL chat — no ETL, local-first, cross-source JOINs. DuckDB Desktop. It has 48 GitHub stars and ranks #230 of 630 in Databases by stars.

Is duckdb-query free and open source?

Yes. duckdb-query is published under the MIT license, so you can run, modify and self-host it at no cost. If it connects to a paid service, that service's own pricing and API terms still apply. Check the repository for the exact license text before using it commercially.

What are the alternatives to duckdb-query?

Other Databases projects on MCP Harbor include Chat2DB, dbx, mcp-toolbox. Each alternative links to its own page with stars, license and recent activity. The Databases category ranks all 630 by stars, and you can re-sort it by growth this week.

Alternatives to duckdb-query

Chat2DB★ 28,331

OtterMind · Java+8 stars this week (+0%)

Chat2DB is a free, cross-platform, local-first database client and SQL workspace for developers, DBAs, analysts, and data teams. Connect to 40+ databases, manage data, edit and run SQL, and use your own AI model to generate, explain, and optimize queries. Available on desktop, web, Docker, and CLI,

dbxTrending★ 27,661

t8y2 · Rust+615 stars this week (+2.3%)

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具，支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库，提供桌面端、Docker、CLI、内置 AI 助手和

mcp-toolbox★ 16,717

googleapis · Go+44 stars this week (+0.3%)

MCP Toolbox for Databases is an open source MCP server for databases.

nightingale★ 13,383

ccfos · Go+17 stars this week (+0.1%)

Open-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.

electric★ 10,412

electric-sql · TypeScript

The agent platform built on sync.

mission-control★ 6,389

builderz-labs · TypeScript+28 stars this week (+0.4%)

Self-hosted control plane for AI agents: dispatch tasks, review runs, track spend, and operate OpenClaw, Claude Code, Codex, and other runtimes.

All 630 Databases MCP servers →

Data last updated 25 October 2026. Stars and downloads are refreshed every day from GitHub and npm.