Sets up robust SQLite persistence with versioned migrations, transactional writes, and repository interfaces.
Install
mkdir -p .claude/skills/sqlite-angelquinterodev && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/18505" && unzip -o skill.zip -d .claude/skills/sqlite-angelquinterodev && rm skill.zipInstalls to .claude/skills/sqlite-angelquinterodev
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Use when implementing persistence with SQLite, schemas, and migrations.Key capabilities
- →Define schema with version table and migration scripts
- →Use WAL mode and enforce foreign keys
- →Use parameterized queries and prepared statements
- →Wrap writes in transactions
- →Provide a repository layer with interface contracts
- →Use indexes on domain, rule ID, and timestamps
How it works
This skill provides a procedure and design guidelines for implementing persistence with SQLite, focusing on schema definition, migrations, and safe concurrency.
Inputs & outputs
When to use sqlite
- →Implementing local database persistence
- →Writing database migration scripts
- →Defining repository layers for SQLite
About this skill
SQLite
When to Use
- Persisting rules, schedules, logs, and configuration
- Implementing local storage with transactions
Goals
- Stable schema with versioned migrations
- Fast reads for policy evaluation
- Safe concurrency with minimal locking
Procedure
- Define schema with version table and migration scripts.
- Use WAL mode and enforce foreign keys.
- Use parameterized queries and prepared statements.
- Wrap writes in transactions.
- Provide a repository layer with interface contracts.
Design Guidelines
- Separate read models for UI stats vs policy data.
- Use indexes on domain, rule ID, and timestamps.
- Keep DB path in a protected app data directory.
Anti-patterns
- Building SQL strings via concatenation.
- Storing large blobs in hot tables.
- Running migrations from UI thread.
Performance Considerations
- Batch writes for log ingestion.
- Use connection pooling or a single writer queue.
Security Considerations
- Protect DB file with ACLs.
- Encrypt sensitive fields if required.
Integration Guidelines
- Repositories live in Infrastructure.
- Application uses repository interfaces only.
Output Checklist
- Schema and migration plan
- Repository interfaces
- Concurrency strategy
When not to use it
- →When building SQL strings via concatenation
- →When storing large blobs in hot tables
- →When running migrations from the UI thread
Limitations
- →Avoid building SQL strings via concatenation
- →Avoid storing large blobs in hot tables
- →Avoid running migrations from UI thread
How it compares
This skill offers a structured approach to SQLite persistence, emphasizing stable schemas, versioned migrations, and safe concurrency, which is more reliable than ad-hoc database implementations.
Compared to similar skills
sqlite side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| sqlite (this skill) | 0 | 2mo | No flags | Intermediate |
| drizzle-orm | 32 | 1mo | No flags | Intermediate |
| database-design | 6 | 6mo | Review | Intermediate |
| prisma-expert | 12 | 6mo | Review | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
You might also like
drizzle-orm
EpicenterHQ
Drizzle ORM patterns for type branding and custom types. Use when working with Drizzle column definitions, branded types, or custom type conversions.
database-design
davila7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
prisma-expert
davila7
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design, or database connection issues.
database-schema-designer
davila7
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
database-migration
wshobson
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
database-migrations-sql-migrations
sickn33
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server