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

sqlspec-sqlite

Manage SQLSpec SQLite adapter configuration, driver behavior, and testing workflows.

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

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 SQLite adapter, ensuring correct configuration, driver behavior, and testing.

Core Features & Use Cases

  • Adapter Configuration: Manages connection_config, driver_features, and statement configurations for SQLite.
  • Driver Behavior: Overrides and implements adapter-specific logic for SQLite transactions and parameter handling.
  • Testing: Facilitates integration testing of the SQLite adapter and its interaction with SQLSpec core.
  • Use Case: Debugging an issue where SQLite-specific data types are not correctly mapped by the SQLSpec adapter during query execution.

Quick Start

Use the sqlspec-sqlite skill to review the adapter's parameter profile for handling date/time values.

Frequently Asked Questions about sqlspec-sqlite

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

FAQPage Schema
How do I configure SQLite adapter connection and driver behavior in SQLSpec?▼

Configure the SQLite adapter in SQLSpec by managing connection_config, driver_features, and statement configurations. This approach correctly implements adapter-specific logic for SQLite transactions and parameter handling.

Why does the SQLSpec adapter incorrectly map SQLite data types during query execution?▼

SQLite data type mapping issues occur when adapter-specific parameter profiles are not configured correctly. Review the adapter's logic to ensure SQLite native features and date/time values are handled properly during query execution.

How do I run integration tests for a SQLite database adapter?▼

Run integration testing for the SQLite database adapter by validating its interaction with SQLSpec core. This process verifies driver behavior, parameter profiles, and adapter-specific logic to ensure correct configuration.

What do I need to know before debugging SQLite adapter logic in SQLSpec?▼

Debugging SQLite adapter logic in SQLSpec requires understanding of SQLSpec core, driver bases, and SQLite's native features. This foundational knowledge is necessary to address implementation and review of parameter profiles.

Does SQLSpec support overriding SQLite transaction handling and parameter profiles?▼

Yes, SQLSpec supports overriding SQLite transaction handling and parameter profiles through adapter-specific logic. This allows customization of driver behavior and statement configurations for testing and implementation.

Related Skills

Explore More Software Engineering Skills→
cofincofin
15

sqlspec-asyncmy

Manage SQLSpec asyncmy adapter configuration, driver behavior, and testing.

Community
Intermediate
cofincofin
15

sqlspec-spanner

Manage SQLSpec Spanner adapter configurations and driver behaviors.

Community
Intermediate
cofincofin
15

sqlspec-bigquery

Manages BigQuery adapter configurations and parameter flows for the SQLSpec framework.

Community
Intermediate
cofincofin
15

sqlspec-adbc

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

Community
Intermediate