Skills
.Work. You
Rest

dba-sqlite

Community

Master SQLite/libSQL database design & optimization.

Software Engineering#schema design#database#optimization#sqlite#libsql#turso#fts5
AuthorMassimilianoPili
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: dba-sqlite
Download link: https://github.com/MassimilianoPili/agent-framework/archive/main.zip#dba-sqlite

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.