skills.rest
rnavarych
rnavarychCOMMUNITY
Explore all skills by this author →
GitHub

role-database:embedded-databases

Guide embedded database selection and configuration for 12 databases.

14|3|Updated Feb 22, 2026
Search Tags:#sqlite#performance tuning#key-value store#database selection#embedded databases#rocksdb
One-click install
npx skills add https://github.com/rnavarych/alpha-engineer --skill role-database-embedded-databases
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: role-database:embedded-databases
Source: https://github.com/rnavarych/alpha-engineer/tree/main/plugins/roles/role-database/skills/embedded-databases
Command: npx skills add https://github.com/rnavarych/alpha-engineer --skill role-database-embedded-databases

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides deep operational guidance for selecting, configuring, and troubleshooting a wide array of embedded databases, ensuring optimal performance and reliability in diverse application environments.

Core Features & Use Cases

  • Database Selection: Offers a decision tree to guide users to the best embedded database (SQL or Key-Value) for their specific needs (mobile, edge, server, Go, C++).
  • Configuration & Tuning: Details core principles and PRAGMA settings for popular databases like SQLite, RocksDB, LMDB, and BoltDB.
  • Use Case: A developer needs to choose a key-value store for a Go application that requires high write throughput and supports Time-To-Live (TTL) for data. This Skill would guide them to BadgerDB and provide configuration examples.

Quick Start

Use this skill to select the best embedded database for a mobile application that requires live objects and cloud synchronization.

Frequently Asked Questions about role-database:embedded-databases

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

FAQPage Schema
How do I choose the best embedded database for a mobile application?▼

To choose an embedded database for a mobile app, evaluate whether you need live objects and cloud synchronization. This Skill provides a decision tree covering options like Realm and ObjectBox tailored for mobile environments.

What is the best key-value store for a Go application with high write throughput?▼

For a Go application requiring high write throughput and Time-To-Live (TTL) support, BadgerDB is the recommended embedded database. It utilizes an LSM-tree architecture optimized for these specific performance needs.

How do I configure SQLite PRAGMA settings for performance tuning?▼

Configuring SQLite PRAGMA settings involves adjusting core operational principles to optimize performance. This Skill details specific PRAGMA configurations to tune SQLite for efficient data storage in diverse application environments.

Does LevelDB support zero-copy reads for edge computing?▼

LevelDB and similar embedded databases like LMDB support zero-copy reads to optimize edge computing workloads. This Skill details core architectural principles including LSM-tree designs and zero-copy read capabilities.

When should I not use RocksDB for desktop application storage?▼

You should not use RocksDB for desktop application storage when your workload does not benefit from LSM-tree architecture or when simpler SQL interfaces suffice. This Skill provides selection criteria to identify constraints and limits.

Related Skills

Explore More Software Engineering Skills→
GenuinehGenuineh

backend-database

Guide database selection and schema design for SQL and NoSQL use cases.

Community
Intermediate
sitharaj88sitharaj88
1

db-sqlite

Generate optimized SQLite schemas, queries, and PRAGMA configurations.

Community
Advanced
Eng0AIEng0AI
15

go-backend-clean-architecture

Generate a Go backend scaffold with Gin, MongoDB, and JWT authentication.

Official
Intermediate
desafindesafin

moai-domain-backend

Design and implement APIs, databases, and microservices architectures.

Community
Advanced