Does this skill support database migrations?

Yes, it includes standard patterns for using Goose with Go's embed package, allowing you to bundle SQL migrations directly into your compiled binary.

Which SQLite driver should I use for Go?

For CLI tools and simple deployment, this skill recommends the pure-Go modernc.org/sqlite driver. For maximum performance where CGO is acceptable, the github.com/mattn/go-sqlite3 driver is preferred.

How can I prevent multiple instances of my Go app from corrupting the database?

The skill implements a single-instance locking pattern using file-based locks (flock) to ensure only one process can access the database file at a time.

How do I handle concurrent writes in SQLite with Go?

The skill provides patterns for enabling WAL (Write-Ahead Logging) mode and setting a busy_timeout, which allow for better concurrency and prevent 'database is locked' errors.

SQLite for Go Development

Name: SQLite for Go Development
Author: ksawaneh

byksawaneh

0•

Database Management

Implements high-performance SQLite patterns in Go applications using best practices for drivers, migrations, and concurrency.

This skill provides Claude with comprehensive domain knowledge to architect robust local-first Go applications using SQLite. It guides developers through critical architectural decisions including driver selection between pure-Go and CGO implementations, XDG-compliant file pathing, and optimal PRAGMA configurations for WAL mode. By integrating patterns for migrations, repository abstractions, and automated backups, it ensures Go applications maintain data integrity and high performance without external database dependencies.

Key Features

01Comprehensive pure-Go vs CGO driver comparison and selection

02Optimized SQLite PRAGMA configurations for WAL and concurrency

03Embedded SQL migration workflows using Goose

04Production-ready Repository Pattern implementations

05Automated backup rotation and single-instance locking mechanisms

060 GitHub stars

Use Cases

01Building cross-platform CLI tools requiring persistent local storage

02Creating embedded databases for Go-based desktop or TUI applications

03Developing local-first applications with high-concurrency needs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ksawaneh/today sqlite-go

For use in Claude.ai and ChatGPT

Download Skill