local-db

Manage local SQLite databases with migrations, queries, and backups.

1|Updated Mar 30, 2026
One-click install
npx skills add https://github.com/Arry8/openclaw-edge --skill local-db
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: local-db
Source: https://github.com/Arry8/openclaw-edge/tree/main/skills/local-db
Command: npx skills add https://github.com/Arry8/openclaw-edge --skill local-db

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

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.

Frequently Asked Questions about local-db

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

FAQPage Schema
How do I manage SQLite database migrations locally without losing data?

Apply SQLite migrations locally with a persistent _migrations log that tracks schema changes, ensuring data integrity and preventing accidental data loss during schema evolution.

What is the best way to backup a local SQLite database safely?

Backup local SQLite databases safely using built-in safety guards that prevent destructive operations, executing secure backups via a simple CLI script without requiring cloud dependencies.

Can I use a Python CLI to create and query SQLite databases offline?

Use a Python CLI script to create, query, and organize SQLite databases under a local directory, providing offline persistent storage and schema inspection for lightweight apps.

Does local SQLite database management require external cloud dependencies?

Local SQLite database management does not require cloud dependencies, as it creates and manages databases locally with input validation and safe destructive operation guards for personal projects.

How do I prevent accidental data loss when running destructive SQLite queries?

Prevent accidental data loss during destructive SQLite queries by relying on built-in safety guards and input validation that intercept and block unsafe operations before execution.