local-db

What problem does it solve?

This tool helps developers and power users create, organize, migrate, query, and backup SQLite databases locally, ensuring data integrity and avoiding accidental data loss.

Core Features & Use Cases

• Create and manage local SQLite databases under the ~/.openclaw/databases directory.
• Apply safe migrations with a persistent _migrations log to track schema changes.
• Execute SQL queries, inspect schemas, list migrations, and perform backups with built-in safety checks.
• Use cases include lightweight apps, personal projects, and prototypes that require offline data storage.

Quick Start

Create a new local database named your_db and start migrating, querying, and backing up data with the localdb.py script.