skills.rest
cirne
cirneCOMMUNITY
Explore all skills by this author →
Website𝕏@sweetlewGitHub

db-dev

Reset and reinitialize the local SQLite database and data directory.

Updated Aug 23, 2026
Search Tags:#development#database#sqlite#reset#no-migrations#data-dir
One-click install
npx skills add https://github.com/cirne/zmail --skill db-dev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-dev
Source: https://github.com/cirne/zmail/tree/main/.cursor/skills/db-dev
Command: npx skills add https://github.com/cirne/zmail --skill db-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Developers often need to start fresh during development, removing stale or corrupted data and resetting the local SQLite database to align with the latest schema.

Core Features & Use Cases

  • Full reset of the local DB and data directory to a clean development state.
  • No migrations: rebuild from scratch on next run to ensure a consistent schema.
  • Guided rebuilds: clears the DB and data paths to support reliable test cycles.

Quick Start

Run a complete reset of your local development environment to recreate the DB and data directory for a pristine start.

Frequently Asked Questions about db-dev

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

FAQPage Schema
How do I reset my local SQLite database to a clean state for development?▼

You can reset your local SQLite database by clearing the existing DB and data paths. This enforces a no-migration policy, deleting stale data so the schema rebuilds from scratch on your next run.

Why does my local database schema need a no-migration policy during development?▼

A no-migration policy ensures your local database rebuilds from scratch on every run, avoiding stale schema conflicts and corrupted local state without writing migration scripts during active development.

What is the best way to clear corrupted local data directories before running tests?▼

The best way to clear corrupted local data directories is to perform a full reset that standardizes the development data layout, wiping both the DB and data paths for reliable test cycles.

Can I use this database reset approach when schema changes occur without losing my development layout?▼

Yes, you can use this reset approach when schema changes occur. It clears the corrupted DB state and standardizes your development data layout, allowing the application to recreate everything cleanly.

Do I need to write migration scripts to rebuild my local development database?▼

No, you do not need to write migration scripts. This approach enforces a no-migration policy, meaning the local SQLite database is completely reset and rebuilt from scratch on the next application run.

Related Skills

Explore More Software Engineering Skills→
kazukinagatakazukinagata
3

sqlite-setup

Configure Waggle to use SQLite as its primary data provider for a local task store.

Community
Intermediate
SAP-samplesSAP-samples
89

load-and-test

Rebuild CDS artifacts, reload SQLite fixtures, and run the full test suite.

Official
Intermediate
paleoterrapaleoterra
2

sqlite-test-validator

Validate SQLite migrations and schemas with sqlite_validator.py CLI commands.

Community
Intermediate
PlazaCCPlazaCC
2

db-migrate

Generate and apply Drizzle ORM migration scripts for Supabase Postgres.

Official
Intermediate