How does this skill help with SQLite performance?

It provides deep-dive implementation details on enabling WAL (Write-Ahead Logging) mode, PRAGMA tuning, and connection pooling for production environments.

What is the best choice for a write-heavy Go application?

BadgerDB is the recommended choice for write-heavy workloads in Go, though you should run value log garbage collection on a schedule.

Which embedded database should I use for a mobile application?

For mobile apps, this skill recommends using Realm for its live object capabilities or SQLite as the standard SQL-based choice.

Can this skill help with edge computing database needs?

Yes, it covers libSQL (Turso) which is specifically designed for edge replicas, HTTP APIs, and vector search in distributed environments.

Embedded Database Expert

Name: Embedded Database Expert
Author: rnavarych

byrnavarych

•

Database Management

Guides the selection, configuration, and performance tuning of 12 major embedded databases including SQLite, RocksDB, and Realm.

This skill provides deep operational expertise for developers building mobile, desktop, and edge applications that require embedded storage. It offers a structured decision tree to help you choose between SQL and Key-Value engines, along with specific implementation patterns for SQLite, RocksDB, LevelDB, LMDB, and specialized mobile engines like Realm and ObjectBox. Whether you are optimizing write-heavy LSM-tree architectures or configuring zero-copy read-heavy workloads, this skill ensures your embedded storage is production-ready with battle-tested tuning strategies.

Key Features

01Production tuning for SQLite including WAL, PRAGMA, and FTS5

02Mobile and edge guidance for Realm, ObjectBox, and libSQL

03Comprehensive decision tree for SQL vs. Key-Value selection

0411 GitHub stars

05Deep operational guides for LSM-tree engines like RocksDB and LevelDB

06Go-specific storage implementation for BadgerDB and BoltDB

Use Cases

01Optimizing high-throughput write performance for storage engines using RocksDB

02Architecting storage for IoT or mobile devices with low resource overhead

03Migrating from standard SQLite to edge-ready solutions like libSQL or Turso

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer embedded-databases

For use in Claude.ai and ChatGPT

Key Features

01Production tuning for SQLite including WAL, PRAGMA, and FTS5

02Mobile and edge guidance for Realm, ObjectBox, and libSQL

03Comprehensive decision tree for SQL vs. Key-Value selection

0411 GitHub stars

05Deep operational guides for LSM-tree engines like RocksDB and LevelDB

06Go-specific storage implementation for BadgerDB and BoltDB

Use Cases

01Optimizing high-throughput write performance for storage engines using RocksDB

02Architecting storage for IoT or mobile devices with low resource overhead

03Migrating from standard SQLite to edge-ready solutions like libSQL or Turso

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer embedded-databases

For use in Claude.ai and ChatGPT