How does this skill handle date and time storage?

It enforces the use of ISO-8601 TEXT strings, which are human-readable, sortable, and fully compatible with SQLite's built-in date and time functions.

Can I use this with an existing database project?

Yes, the skill is designed to respect existing repository patterns and includes an audit step before suggesting schema changes or PRAGMA updates.

Does this skill support older versions of SQLite?

While the skill prioritizes features like STRICT tables (3.37+), it includes compatibility guidelines for auditing and maintaining legacy databases and network filesystems.

Why is WAL mode recommended by these conventions?

WAL (Write-Ahead Logging) allows multiple readers to operate simultaneously without blocking a writer, which is essential for application performance and concurrency.

SQLite Development Conventions

Name: SQLite Development Conventions
Author: jsamuelsen11

byjsamuelsen11

0•

Database Management

Implements standardized best practices for SQLite database design, performance optimization, and schema integrity.

This skill provides Claude with a comprehensive set of conventions for SQLite development, ensuring optimal performance and data integrity across all SQLite 3.40+ environments. It covers critical areas such as PRAGMA configurations for WAL mode and foreign keys, strict typing via STRICT tables, standardized ISO-8601 date storage, and efficient primary key patterns. By applying these patterns, developers can avoid common pitfalls like silent type conversion, concurrency bottlenecks, and non-portable schema designs, making it an essential tool for building robust embedded database systems.

Key Features

010 GitHub stars

02Guidelines for handling specific data types like UUIDs, Booleans, and Cents-based currency

03Performance-optimized schema design including indexing and primary key patterns

04Standardized ISO-8601 date and time handling for query compatibility

05Automated PRAGMA configuration for WAL mode and foreign key enforcement

06Implementation of STRICT tables for modern type safety and data integrity

Use Cases

01Ensuring consistent data types and naming conventions across team-based database projects

02Architecting a new high-performance SQLite database for a production-grade application

03Refactoring legacy SQLite schemas to utilize modern STRICT table features and WAL mode

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jsamuelsen11/claude-config sqlite-conventions

For use in Claude.ai and ChatGPT

Download Skill