Provides commands and patterns for embedding SQLite databases in applications.
Install
mkdir -p .claude/skills/sqlite-ssrjkk && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/19170" && unzip -o skill.zip -d .claude/skills/sqlite-ssrjkk && rm skill.zipInstalls to .claude/skills/sqlite-ssrjkk
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.
Embeds SQLite databases in applications with zero configuration and single-file storage. Use for local data persistence.Key capabilities
- →Create SQLite database files
- →Define database schemas using SQL
- →Insert data into tables
- →Query data from tables
- →List tables in a database
- →Show schema for a specific table
How it works
The skill uses the `sqlite3` command-line tool to create and interact with SQLite databases, allowing for schema definition, data insertion, and querying.
Inputs & outputs
When to use sqlite
- →Embed SQLite in app
- →Define database schema
- →Query local data
About this skill
SQLite
Self-contained, serverless, zero-configuration SQL database engine.
Quick Start
sqlite3 mydb.db
CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT UNIQUE NOT NULL);
INSERT INTO users (name, email) VALUES ('Alice', '[email protected]');
SELECT * FROM users;
CLI Commands
.tables # List tables
.schema users # Show schema
.mode json # JSON output
.headers on # Show column headers
Python Integration
import sqlite3
conn = sqlite3.connect('mydb.db')
cursor = conn.execute('SELECT * FROM users WHERE id = ?', (1,))
When to Use
- Mobile app storage
- Desktop application data
- Prototypes and testing
- Embedded/IoT devices
Validation
- Database file creates correctly
- SQL queries execute without error
- Transactions commit and rollback
When not to use it
- →When a client-server database architecture is required
- →When data persistence is not local or single-file
Limitations
- →Designed for local data persistence
- →Self-contained, serverless database engine
- →Zero-configuration setup
How it compares
This skill provides a zero-configuration, single-file approach to database management, suitable for embedded applications, unlike traditional client-server database systems.
Compared to similar skills
sqlite side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| sqlite (this skill) | 0 | 12d | Review | Beginner |
| sql-optimization-patterns | 64 | 2mo | No flags | Advanced |
| drizzle-orm | 32 | 1mo | No flags | Intermediate |
| qdrant-vector-search | 18 | 8mo | Review | Advanced |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by ssrjkk
View all by ssrjkk →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.