skills.rest
cofin
cofinCOMMUNITY
Explore all skills by this author →
GitHub

sqlspec-duckdb

Manage SQLSpec DuckDB adapter configuration, debugging, and review workflows.

15|4|Updated Jan 20, 2026
Search Tags:#testing#database#sql#duckdb#adapter#sqlspec
One-click install
npx skills add https://github.com/cofin/flow --skill sqlspec-duckdb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlspec-duckdb
Source: https://github.com/cofin/flow/tree/main/skills/sqlspec-duckdb
Command: npx skills add https://github.com/cofin/flow --skill sqlspec-duckdb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill streamlines the implementation, debugging, and review of SQLSpec's DuckDB adapter, ensuring correct configuration and driver behavior.

Core Features & Use Cases

  • Adapter Configuration: Manages connection_config, driver_features, and statement configurations for DuckDB.
  • Driver Behavior: Addresses DuckDB-specific transaction handling and parameter passing.
  • Use Case: When developing new features for the SQLSpec DuckDB adapter, use this Skill to ensure all parameter profiles are correctly implemented and tested against DuckDB's specific SQL dialect and transaction model.

Quick Start

Use the sqlspec-duckdb skill to review the adapter implementation for DuckDB.

Frequently Asked Questions about sqlspec-duckdb

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I configure a SQLSpec adapter for DuckDB?▼

Configuring a SQLSpec adapter for DuckDB involves managing connection_config, driver_features, and statement configurations. This Skill handles adapter configuration to ensure correct parameter passing and driver behavior specific to DuckDB.

How does DuckDB transaction handling work with SQLSpec?▼

DuckDB transaction handling with SQLSpec requires adapting driver behavior to match DuckDB's specific transaction model. This Skill reviews and debugs adapter implementations to ensure parameter profiles align with DuckDB's transaction nuances.

What do I need to know to implement a DuckDB adapter in SQLSpec?▼

Implementing a DuckDB adapter in SQLSpec requires understanding SQLSpec's adapter architecture alongside DuckDB's SQL dialect. You need to correctly implement parameter profiles and driver behaviors specific to DuckDB.

Why are my SQLSpec DuckDB adapter parameter profiles not working?▼

SQLSpec DuckDB adapter parameter profiles fail when they do not align with DuckDB's specific SQL dialect and parameter passing rules. Use this Skill to debug adapter configurations and verify parameter profiles against DuckDB's driver behavior.

Can I use SQLSpec to test DuckDB-specific SQL dialect behaviors?▼

Yes, SQLSpec tests DuckDB-specific SQL dialect behaviors by managing adapter configurations and parameter profiles. This Skill ensures features are correctly implemented and tested against DuckDB's specific transaction model and SQL dialect.

What is the best way to review a SQLSpec DuckDB adapter implementation?▼

Reviewing a SQLSpec DuckDB adapter implementation involves verifying connection_config, driver_features, and parameter profiles against DuckDB's SQL dialect. This Skill streamlines the review process to ensure correct driver behavior.

Related Skills

Explore More Software Engineering Skills→
cofincofin
15

sqlspec-aiosqlite

Manage SQLSpec aiosqlite adapter configurations, driver behavior, and tests.

Community
Intermediate
cofincofin
15

sqlspec-adbc

Manage SQLSpec ADBC adapter configurations, driver behavior, and parameter profiles.

Community
Intermediate
cofincofin
15

sqlspec-spanner

Manage SQLSpec Spanner adapter configurations and driver behaviors.

Community
Intermediate
cofincofin
15

sqlspec

Provide type-safe SQL query mapping for Python with database adapter support.

Community
Advanced