SQLite Database Expert
Expert in SQLite embedded database development for Tauri/desktop applications with focus on SQL injection prevention, migrations, FTS search, and secure data handling
Install
npx skills add martinholovsky/claude-skills-generator --skill SQLite Database Expertgit clone --depth 1 https://github.com/martinholovsky/claude-skills-generator.git /tmp/claude-skills-generator
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills-generator/skills/sqlite ~/.claude/skills/SQLite-Database-ExpertPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# SQLite Database Expert ## 0. Mandatory Reading Protocol **CRITICAL**: Before implementing ANY database operation, you MUST read the relevant reference files: ### Trigger Conditions for Reference Files **Read `references/advanced-patterns.md` WHEN**: - Implementing database migrations - Setting up Full-Text Search (FTS5) - Designing complex queries with CTEs or window functions - Implementing connection pooling or WAL mode - Performance optimization tasks **Read `references/security-examples.md` WHEN**: - Writing ANY SQL query with user input - Implementing parameterized queries - Setting up database encryption considerations - Handling sensitive data storage - Implementing input validation for database operations --- ## 1. Overview **Risk Level: MEDIUM** **Justification**: SQLite databases in desktop applications handle user data locally, present SQL injection risks if queries aren't properly parameterized, and require careful migration management to prevent data loss. You are an expert in SQLite embedded database development, specializing in: - **Secure SQL patterns** with parameterized queries to prevent SQL injection - **Database migrations** with version control and rollback capabilities - **Full-Text Search (FTS5)** for efficient text searching - **Performance optimization** including indexing, WAL mode, and connection management - **Rust/Tauri integration** using rusqlite and sea-query ### Core Principles
Details
- Skill name
SQLite Database Expert- Repository
- martinholovsky/claude-skills-generator
- Path
skills/sqlite/SKILL.md- License
- Unlicense
- Repo updated
- 6 December 2025
FAQ
What does the SQLite Database Expert skill do?
Expert in SQLite embedded database development for Tauri/desktop applications with focus on SQL injection prevention, migrations, FTS search, and secure data handling
How do I install the SQLite Database Expert skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add martinholovsky/claude-skills-generator --skill SQLite Database Expert. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is SQLite Database Expert popular?
It lives in martinholovsky/claude-skills-generator, which has 48 GitHub stars and 4 forks.
Related skills
API Expert
48martinholovsky/claude-skills-generator
Expert API architect specializing in RESTful API design, GraphQL, gRPC, and API security. Deep expertise in OpenAPI 3.1, authentication patterns (OAuth2, JWT), rate limiting, pagination, and OWASP API Security Top 10. Use when designing scalable APIs, implementing API gateways, or securing API endpoints.
Applescript
48martinholovsky/claude-skills-generator
Expert in AppleScript and JavaScript for Automation (JXA) for macOS system scripting. Specializes in secure script execution, application automation, and system integration. HIGH-RISK skill due to shell command execution and system-wide control capabilities.
Appsec Expert
48martinholovsky/claude-skills-generator
Elite Application Security engineer specializing in secure SDLC, OWASP Top 10 2025, SAST/DAST/SCA integration, threat modeling (STRIDE), and vulnerability remediation. Expert in security testing, cryptography, authentication patterns, and DevSecOps automation. Use when securing applications, implementing security controls, or conducting security assessments.
Aiven
57javimosch/supercli
aiven — Aiven CLI. Manage Aiven cloud data services: PostgreSQL, Kafka, OpenSearch, Redis.
SQLCipher Encrypted Database Expert
48martinholovsky/claude-skills-generator
Expert in SQLCipher encrypted database development with focus on encryption key management, key rotation, secure data handling, and cryptographic best practices
Angle Grinder
57javimosch/supercli
angle-grinder — log file analysis CLI. Query and aggregate log files with SQL-like expressions.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.