skills.rest
jsamuelsen11
jsamuelsen11COMMUNITY
Explore all skills by this author →
GitHub

sqlite-conventions

Enforce SQLite conventions for PRAGMA configuration, type affinity, and STRICT tables.

Updated Feb 7, 2026
Search Tags:#database#compatibility#sqlite#schema-design#strict#pragmas
One-click install
npx skills add https://github.com/jsamuelsen11/claude-config --skill sqlite-conventions
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlite-conventions
Source: https://github.com/jsamuelsen11/claude-config/tree/main/plugins/ccfg-sqlite/skills/sqlite-conventions
Command: npx skills add https://github.com/jsamuelsen11/claude-config --skill sqlite-conventions

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Comprehensive guidelines to ensure robust, portable SQLite schemas and configurations across projects, covering PRAGMA settings, type affinity, STRICT tables, naming conventions, and compatibility practices.

Core Features & Use Cases

  • PRAGMA configuration and per-connection vs per-database settings to optimize performance and reliability.
  • Type affinity rules, STRICT table usage, NOT NULL defaults, and canonical data modeling guidance.
  • Schema design rules including naming conventions, constraints, and indexing strategies, plus a compatibility matrix for SQLite features.
  • Use Case: when building a mobile or embedded app with local storage, apply these conventions to maintain consistency across versions and platforms.

Quick Start

Review these conventions before creating or updating any SQLite schema in your project.

Frequently Asked Questions about sqlite-conventions

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

FAQPage Schema
What SQLite PRAGMA configurations should I use for local app data storage?▼

Configuring SQLite PRAGMAS correctly ensures database reliability and portability across platforms. You should codify per-connection PRAGMAS separately from per-database settings to optimize performance for embedded apps and local data stores.

How do I enforce strict data types in SQLite schema design?▼

To enforce strict data types in SQLite schema design, use STRICT tables and type affinity rules. Applying these conventions ensures canonical data modeling and reliable NOT NULL defaults across your application's local storage.

What are the best naming conventions and indexing strategies for SQLite databases?▼

The best SQLite naming conventions and indexing strategies involve codifying clear schema design rules for constraints and structure. Applying these guidelines maintains database consistency across different versions and platforms.

Does this SQLite convention guideline work for mobile and embedded apps?▼

Yes, these SQLite conventions are explicitly suitable for mobile and embedded apps with local storage. The guidelines help maintain consistency across versions and platforms through a compatibility matrix for SQLite features.

How do I manage SQLite compatibility across different database versions?▼

To manage SQLite compatibility across versions, reference a compatibility matrix for SQLite features and codify project pipelines. This practice ensures portable schemas and configurations function reliably across different environments.

Related Skills

Explore More Software Engineering Skills→
simplerick0simplerick0

sqlite

Optimize embedded SQLite schemas with WAL, indexing, and pragma tuning.

Community
Intermediate
DexploarerDexploarer
7

golden-path-creator

Define and enforce golden paths and best practices for development teams.

Community
Intermediate
Cap-goCap-go
58

capacitor-offline-first

Implement offline-first data synchronization for Capacitor apps with SQLite.

Official
Advanced
L3DigitalNetL3DigitalNet
6

sqlite

Administer SQLite databases with queries, schema inspection, import/export, backups, and PRAGMA tuning.

Official
Intermediate