Can I use this skill to implement search features?

Yes, it includes specific patterns for Full-Text Search (FTS5) including table creation, population, and ranking by relevance.

What library does this skill assume for SQLite interactions?

This skill primarily provides patterns compatible with the better-sqlite3 library, known for its performance and synchronous API in Node.js environments.

How does it handle performance optimization?

The skill provides configurations for Write-Ahead Logging (WAL) mode, synchronous settings, and cache sizing to ensure high-concurrency performance and reliability.

Does it support advanced SQL features?

Yes, it includes implementation guides for Window functions, JSON data extraction/updates, and nested transactions using savepoints.

SQLite Patterns & Best Practices

Name: SQLite Patterns & Best Practices
Author: bradtaylorsf

bybradtaylorsf

•

Gestión de Bases de Datos

Provides optimized SQLite implementation patterns, database schemas, and advanced query techniques for Node.js environments.

This skill equips Claude with standardized patterns for working with SQLite databases, specifically optimized for the better-sqlite3 driver. It covers the full lifecycle of database management, from initial setup and table creation to advanced features like Full-Text Search (FTS5), JSON functions, and performance tuning via Write-Ahead Logging (WAL) mode. By utilizing these patterns, developers can ensure data integrity through robust transactions, implement efficient indexing strategies, and follow industry best practices for data typing and soft deletes in lightweight relational databases.

Características Principales

01Standardized CRUD operations using better-sqlite3 and prepared statements

02Robust transaction management with support for nested savepoints

036 GitHub stars

04Standardized patterns for ISO date/time handling and boolean data types

05Advanced query implementations including JSON handling and Full-Text Search (FTS5)

06Database performance optimization patterns including WAL mode and caching

Casos de Uso

01Managing complex data relationships and transactions in a lightweight backend environment

02Setting up a local persistent data store for a Node.js CLI or desktop application

03Implementing high-performance search functionality using SQLite's virtual tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bradtaylorsf/alphaagent-team sqlite-patterns

For use in Claude.ai and ChatGPT

Download Skill