skills.rest
MassimilianoPili
MassimilianoPiliCOMMUNITY
Explore all skills by this author →
GitHub

dba-sqlite

Design, optimize, and manage SQLite and libSQL databases with PRAGMA settings and indexing.

Updated Mar 7, 2026
Search Tags:#schema design#database#optimization#sqlite#libsql#turso#fts5
One-click install
npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-sqlite
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba-sqlite
Source: https://github.com/MassimilianoPili/agent-framework/tree/main/.claude/agents/dba-sqlite
Command: npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-sqlite

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the complexities of designing, optimizing, and managing SQLite and libSQL databases, ensuring efficient and robust data storage for embedded and serverless applications.

Core Features & Use Cases

  • Schema Design & Optimization: Implement best practices for PRAGMA settings, data types, and indexing.
  • Advanced Features: Utilize FTS5 for full-text search, R*Tree for spatial data, and JSON1 for semi-structured data.
  • libSQL/Turso Support: Handle HTTP API patterns and replication for serverless deployments.
  • Use Case: Optimize a SQLite database for a mobile application by implementing WAL mode, configuring cache size, and adding an FTS5 index for fast text searching within user-generated content.

Quick Start

Use the dba-sqlite skill to create an FTS5 virtual table for full-text search on the 'documents' table.

Frequently Asked Questions about dba-sqlite

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize SQLite performance for a high-concurrency application?▼

Optimize SQLite performance by enabling WAL mode, configuring PRAGMA cache size settings, and applying advanced indexing techniques like FTS5 for full-text search and R*Tree for spatial data.

Can I use SQLite for serverless deployments with HTTP API access?▼

Yes, libSQL supports serverless deployments through its HTTP API patterns and replication capabilities, enabling distributed SQLite access for modern web applications.

What is the best way to implement full-text search in SQLite?▼

Implement full-text search in SQLite by creating FTS5 virtual tables on target tables like 'documents', enabling fast text searching across user-generated content and semi-structured data.

Does libSQL support spatial data queries and JSON manipulation?▼

libSQL handles spatial data through R*Tree indexing structures and semi-structured data via JSON1 extension, enabling efficient spatial queries and JSON document manipulation within the database.

When should I use PRAGMA settings for SQLite schema design?▼

Configure PRAGMA settings during schema design to enforce strict data typing, enable WAL journal mode, and tune cache size for optimal read and write performance.

How do I handle schema evolution in SQLite without breaking existing queries?▼

Handle schema evolution in SQLite by adhering to contract-first principles, ensuring backward-compatible changes through efficient data typing and careful indexing management.

Related Skills

Explore More Software Engineering Skills→
yutnayutna
2

drizzle-patterns

Enforce centralized Drizzle ORM database patterns with SQLite/libSQL schemas, migrations, and seeds.

Community
Advanced
RepairYourTechRepairYourTech
6

sqlite

Guide SQLite development with performance tuning, FTS5, JSON, and replication.

Community
Advanced
baphledbaphled
1

gorm-repository

Implement GORM repository patterns for Go applications with SQLite.

Community
Intermediate
afonsoftafonsoft
1

postgresql-optimization

Optimize PostgreSQL queries using JSONB, arrays, and custom types.

Community
Advanced