SkillFoxx

Quack on Demand plugin

A Claude Code plugin with an operator runbook: an agent runs a DuckDB gateway, tenants, rights and queries through the qod CLI.

  • 145 ★ on the repository
  • Last commit
  • Apache-2.0
Plugin

Extended access

Why this level

  • The agent can change tenants, roles and access policies on a live gateway.
  • The gateway opens Flight SQL ports and a web admin console.
All reasons and checks

starlake-ai/quack-on-demandAuthor:starlake-ai

Install

In your terminal, with SkillFoxx CLI

npx skillfoxx add plugins/quack-on-demand

Detects the agents on your machine, shows the access level and pins the version.

Other ways to install

Access and checks

How we review

Extended accessThe tool runs code or makes network calls and only reads external data.

  • The agent can change tenants, roles and access policies on a live gateway.
  • The gateway opens Flight SQL ports and a web admin console.

This is third-party code. Review the repository files before installing.

What it does

Quack on Demand is an open source serving layer for DuckDB and DuckLake with Arrow Flight SQL access, and it ships with an agent plugin. The plugin holds an operator runbook that lets an agent work with a live gateway manager through the `qod` CLI: boot and stop the manager, manage tenants and pools, rights and policies, inspect nodes and run SQL. The gateway itself offers several tenants on one server, table, row and column level security, several sign-in methods (database, JWT, OIDC) and a web admin console. Quick start is one command, `uvx qod@latest serve --demo`, and for your own data the gateway runs over a DuckDB file, a parquet directory or an S3 prefix.

Who it is for. Data and platform engineers who serve DuckDB to several teams and want to hand routine gateway administration to an agent.

Good fit when

  • A tenant and pool must be created and table rights granted in one request.
  • An agent checks node state and runs diagnostic SQL.
  • The gateway hardening checklist from `SKILL.md` is walked before deployment.
  • A demo gateway starts on a laptop to test an idea.

Not a fit when

  • You need distributed joins across nodes, since each statement runs on one DuckDB node.
  • Data runs to terabytes and needs a cluster such as Trino.
  • The agent must not be allowed to change rights and policies.

Example request

Start a Quack on Demand demo gateway, create an analytics tenant with a two-node pool and give a group read-only access to the sales table.

Limitations

The plugin drives a live manager, so the agent can change tenants, roles and access policies. Give it an account with the minimum rights it needs. The admin password is entered by hand on first run or set through `QOD_ADMIN_PASSWORD` and is never stored. By design the gateway has no distributed joins between nodes. The hardening guide lives in `plugins/qod/skills/quack-on-demand/SKILL.md`.

How to disable. Run `/plugin uninstall quack-on-demand` in Claude Code or delete the skill from the agent folder. Stop the gateway itself with `uvx qod@latest stop`.

FAQ

How do I install the skill through the CLI?

Run `qod skill install` after `uv tool install qod` or `pip install qod`. It asks which assistant to install for: Claude Code, GitHub Copilot or Gemini CLI.

How do I run a gateway on my data?

Use `uvx qod@latest serve ./sales.duckdb`, and for a directory of files or a remote path substitute the directory or an `s3://` address.

Where is the admin UI?

The admin interface is at `http://localhost:20900/ui/`, with Flight SQL on port 31338 and native Quack on port 9494.

What if I forget the admin password?

Run `uvx qod@latest admin reset-password` to recover access.

Is Postgres needed?

Not for `--demo` or a run over a file: the README stresses that the demo needs no install and no Postgres.

Discussion

No questions or reviews yet.

Plugins
Official

The MCP server of the Duckle platform: an agent builds, checks and runs DuckDB ETL pipelines on your machine

MCP serverBroad access1.6K
Official

21 skills for agents on MotherDuck: app connections, DuckDB SQL queries, Dives and Flights, pipelines and analytics apps.

PluginExtended access62
Official

A temporary DuckDB sandbox: an agent loads a CSV and queries the data over MCP or REST without touching the production database

MCP serverExtended access21

DuckDB plugin for Claude Code: SQL over CSV, Parquet and databases, S3 file reading, and search across docs and session logs

PluginExtended access617

The Dex plugin: an agent explores a database, builds dbt models and a semantic layer and tracks schema drift under cost control

PluginExtended access119

DuckDB / MotherDuck MCP Server

DuckDB / MotherDuck Local MCP Server

Official

An MCP server for SQL analytics on DuckDB: local files, in-memory databases, S3-hosted databases and MotherDuck

MCP serverExtended access540

README in short

The gateway keeps data on the server and serves it through Flight SQL with access policies. The plugin adds an operator runbook to Claude Code rather than a separate copy of the product.

README badge

Report a problem