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

48 stars 4 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add martinholovsky/claude-skills-generator --skill SQLite Database Expert
Manual install
git 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-Expert

Personal 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
Read the full skill on GitHub

Details

Skill name
SQLite Database Expert
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

48

martinholovsky/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.

Software Development

Applescript

48

martinholovsky/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.

Productivity & Notes

Appsec Expert

48

martinholovsky/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.

Security

Aiven

57

javimosch/supercli

aiven — Aiven CLI. Manage Aiven cloud data services: PostgreSQL, Kafka, OpenSearch, Redis.

DatabasesIn 1 list

SQLCipher Encrypted Database Expert

48

martinholovsky/claude-skills-generator

Expert in SQLCipher encrypted database development with focus on encryption key management, key rotation, secure data handling, and cryptographic best practices

Databases

Angle Grinder

57

javimosch/supercli

angle-grinder — log file analysis CLI. Query and aggregate log files with SQL-like expressions.

DatabasesIn 1 list

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.