working-with-sqlite
Best practices for SQLite tuning, including PRAGMA settings and transaction management for performance.
Install
mkdir -p .claude/skills/working-with-sqlite && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/12315" && unzip -o skill.zip -d .claude/skills/working-with-sqlite && rm skill.zipInstalls to .claude/skills/working-with-sqlite
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.
Preferences and tricks for working with SQLite databasesKey capabilities
- →Set `PRAGMA journal_mode = WAL`
- →Set `PRAGMA busy_timeout = 5000`
- →Set `PRAGMA synchronous = NORMAL`
- →Set `PRAGMA cache_size = 1000000000`
- →Use `BEGIN IMMEDIATE` transactions
- →Use `STRICT` tables
How it works
The skill applies specific PRAGMA settings for SQLite databases to optimize performance and concurrency. It also recommends using `BEGIN IMMEDIATE` transactions, `STRICT` tables, and a specific order for creating tables with large datasets.
Inputs & outputs
When to use working-with-sqlite
- →Optimizing SQLite performance
- →Tuning database settings
- →Managing large data transactions
- →Configuring read-only connections
About this skill
You're already an expert in SQL, and especially SQLite. Here are our preferences:
PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 5000;
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = 1000000000;
PRAGMA foreign_keys = true;
PRAGMA temp_store = memory;
Also:
- Use
BEGIN IMMEDIATEtransactions. - Use
STRICTtables.
When creating tables with lots of data:
- create table,
- insert rows in large transactions, with 10s of thousands of rows a time,
- then create indices at the end.
ANALYZEandVACUUMif necessary
Use read-only connections when appropriate:
conn = sqlite3.connect('file:database.db?mode=ro', uri=True)
When not to use it
- →When creating indices before inserting rows in large transactions
Limitations
- →Requires manual application of PRAGMA settings
- →Requires specific ordering for table creation and index building with large datasets
How it compares
This skill provides a set of optimized configurations and best practices for SQLite, enhancing performance and data integrity beyond default settings or generic SQL usage.
Compared to similar skills
working-with-sqlite side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| working-with-sqlite (this skill) | 0 | 5mo | No flags | Beginner |
| sql-optimization-patterns | 64 | 2mo | No flags | Advanced |
| drizzle-orm | 32 | 2mo | No flags | Intermediate |
| qdrant-vector-search | 18 | 8mo | Review | Advanced |
Try saying
Example prompts that trigger this skill in your AI assistant.
You might also like
sql-optimization-patterns
wshobson
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
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.
qdrant-vector-search
zechenzhangAGI
High-performance vector similarity search engine for RAG and semantic search. Use when building production RAG systems requiring fast nearest neighbor search, hybrid search with filtering, or scalable vector storage with Rust-powered performance.
postgres-patterns
affaan-m
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
postgresql-table-design
wshobson
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
agentdb-advanced-features
ruvnet
Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and distributed systems integration. Use when building distributed AI systems, multi-agent coordination, or advanced vector search applications.