duckdb-acp

🥈Silver

DuckDB ACP enables natural language to SQL queries using AI agents like Claude Code. Operations teams can query data in plain English, reducing SQL dependency and speeding up analysis. It integrates directly into DuckDB workflows, connecting with existing data pipelines and tools.

3720Updated 1mo ago

Intermediate30min to implementautomation

Saves ~75 min per use

Quick InstallView Source

git clone https://github.com/sidequery/duckdb-acp.git

Works with:

Claude

Overview

About This Skill

Setup & Installation

Quick Install

No install command available. Check the GitHub repository for manual installation instructions.

Alternative Install (Git Clone)

git clone https://github.com/sidequery/duckdb-acp

Requirements

Claude Code or compatible AI agent
Works with: Claude

Quick Start Guide

Install the Skill

Copy the install command above and run it in your terminal.

Open Your AI Agent

Launch Claude Code, Cursor, or your preferred AI coding agent.

Try It Out

Use the prompt template or examples below to test the skill.

Customize

Adapt the skill to your specific use case and workflow.

Usage Examples

Prompt Template

Convert the following natural language query into a DuckDB SQL query: [QUERY]. The query should be optimized for performance and return the most relevant results. The data is stored in a DuckDB database with the following schema: [SCHEMA].

Example Output

# SQL Query
```sql
SELECT
    date,
    COUNT(*) AS total_orders,
    SUM(amount) AS total_revenue
FROM
    orders
WHERE
    date BETWEEN '2023-01-01' AND '2023-12-31'
GROUP BY
    date
ORDER BY
    date;
```

# Explanation
The above SQL query will:
- Filter orders from the year 2023
- Group the results by date
- Calculate the total number of orders and total revenue for each day
- Order the results chronologically

This query provides a daily summary of order activity and revenue for the specified year.