sidequery

Duckdb Acp — AI skill for Claude Code

AI community

Use Claude Code & other AI agents from inside DuckDB via extension.

How to install Duckdb Acp

This entry records only its repository, not the path inside it, so there is no exact command to give. Open sidequery/duckdb-acp and copy the folder into ~/.claude/skills/, or the file into ~/.claude/agents/.

What Duckdb Acp does

Use Claude Code & other AI agents from inside DuckDB via extension.

Alternatives in AI

Fast Agent — Code, Build and Evaluate agents - excellent Model and Skills/MCP/ACP Support 3.7k ★
Internal Safety Collapse — We built an adversarial codespace setup 1.2k ★
Wechat Acp — Bridge WeChat chat messages to any ACP-compatible AI agent (Claude, Codex, Copilot, Qwen, Gemini, OpenCode and 488 ★

README

DuckDB ACP

A DuckDB extension that enables natural language to SQL using the [Agent Client Protocol (ACP)](https://agentclientprotocol.com/). Query your data with plain English.

Features

Natural language queries: Write queries in plain English instead of SQL
Statement syntax: CLAUDE show me the top 10 customers by revenue
Table function: SELECT * FROM claude('what products sold the most last month?')
Schema-aware: The agent explores your database schema to generate accurate queries
Safe mode: Blocks mutation queries (INSERT, UPDATE, DELETE) by default

Supported Agents

Claude Code
Codex
Gemini

Quick Start

-- Load the extension
LOAD 'acp.duckdb_extension';

-- Create some sample data
CREATE TABLE sales (id INT, product VARCHAR, amount DECIMAL, sale_date DATE);
INSERT INTO sales VALUES
    (1, 'Widget', 99.99, '2024-01-15'),
    (2, 'Gadget', 149.99, '2024-01-16'),
    (3, 'Widget', 99.99, '2024-01-17');

-- Query with natural language (statement syntax)
CLAUDE what is the total revenue by product?

-- Or use the table function
SELECT * FROM claude('which product has the highest average sale amount?');

Requirements

DuckDB 1.1.0+
bun or Node.js (for npx)
Valid Anthropic API credentials configured for Claude Code

Configuration

Setting	Type	Default	Description
`acp_agent`	VARCHAR	`claude-code`	Agent command or path
`acp_safe_mode`	BOOLEAN	`true`	Block mutation queries
`acp_debug`	BOOLEAN	`false`	Enable verbose debug output
`acp_show_messages`	BOOLEAN	`false`	Stream agent thinking to output
`acp_show_sql`	BOOLEAN	`false`	Print generated SQL before executing
`acp_show_summary`	BOOLEAN	`false`	Show analysis summary from agent
`acp_show_datasources`	BOOLEAN	`false`	Show d