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

Ready to run

npx skills add https://github.com/cofin/flow --skill sqlspec-sqlite

💬 Prompt for ChatGPT / Claude Chat▼

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.