SQLite Database Expert

This one enforces a mandatory reading protocol before you touch the database, which is either brilliant or annoying depending on your tolerance for guardrails. It triggers reference docs for advanced patterns when you're doing migrations, setting up FTS5, or working with CTEs and window functions. The approach assumes you need structured guidance for SQLite's trickier features rather than just winging it. Could be genuinely helpful if you're dealing with production SQLite deployments where WAL mode and connection pooling actually matter, less so if you're just spinning up a local dev database. The skill comes from a generator repo, so it's probably template driven rather than deeply customized.

skills.sh installs: 1
GitHub stars: 45
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add martinholovsky/claude-skills-generator --skill 'SQLite Database Expert' --agent claude-code

Installs into .claude/skills of the current project.

Files

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.

SKILL.md on GitHub