Menu
Install ADBC (Arrow Database Connectivity) drivers with dbc. Use when the user wants to install database drivers and connect to databases.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Query external databases from DuckDB using the ADBC (Arrow Database Connectivity) community extension. Use when the user wants to run SQL against any database with an ADBC driver (BigQuery, ClickHouse, Databricks, PostgreSQL, MySQL, Redshift, SingleStore, Snowflake, SQL Server, SQLite, Trino, etc.) from within DuckDB, attach an external database as a DuckDB catalog, read remote data with `read_adbc`, execute arbitrary remote DDL/DML with `adbc_execute`, or manage ADBC connection profiles/drivers via `dbc`.
Query SQL databases with the databow CLI. Use when the user wants to run SQL queries against any database with an ADBC driver (BigQuery, ClickHouse, Databricks, DataFusion, DuckDB, Exasol, Microsoft SQL Server, MySQL, PostgreSQL, Redshift, SingleStore, Snowflake, Spark, SQLite, Trino, etc.), export query results to JSON/CSV/Arrow IPC files, or work with ADBC connection profiles.
Connect to and work with databases using Arrow Database Connectivity (ADBC). Use whenever the user needs to use a database.
| name | dbc |
| description | Install ADBC (Arrow Database Connectivity) drivers with dbc. Use when the user wants to install database drivers and connect to databases. |
| license | Apache-2.0 |
| metadata | {"author":"Columnar","version":"1.1.2"} |
Install and manage drivers for the user with the dbc command line program.
If the user does not have dbc available, try to install it for them.
Prefer installing it with these commands, in order of preference, if the tool is available:
uv is available: uv tool install dbcpipx is available: pipx install dbcbrew is available: brew install columnar-tech/tap/dbcwinget is available: winget install dbcIf none of the above options are available, stop and ask the user if they want to install dbc themselves manually before proceeding. Direct them to the installation docs: https://docs.columnar.tech/dbc/getting_started/installation/.
dbc install <driver> - Install a driver (e.g., dbc install snowflake)dbc search [pattern] - Search for a driver using a pattern (e.g., dbc search sql). Also lists installed drivers (see below).dbc info <driver> - Get driver detailsRun dbc --help to learn about other commands.
There is no dbc list command. Do not run dbc list โ it will fail.
To see which drivers are already installed, run dbc search with no arguments (or with a pattern) and look for entries marked [installed: ...] in the output. For example:
postgresql An ADBC driver for PostgreSQL ... [installed: user=>1.11.0]
snowflake An ADBC driver for Snowflake ... [installed: user=>1.10.3]
Entries without an [installed: ...] tag are available but not yet installed.
For reproducible driver management, prefer using this workflow over dbc install:
dbc init - Create a dbc.toml filedbc add <driver> - Add drivers to the list (supports version constraints like dbc add "postgresql>=13.0")dbc sync - Install all drivers and create dbc.lockDrivers installed with dbc must be used with an ADBC driver manager. dbc cannot load a driver or query a data source directly. Don't install drivers from any other source like PyPI, prefer drivers installed with dbc always.
Resources for using drivers: