skills.rest
dimitriRemoiville
dimitriRemoivilleCOMMUNITY
Explore all skills by this author →
GitHub

drift-persistence

Manage encrypted Flutter local storage with drift and sqlcipher migrations.

1|Updated Apr 24, 2026
Search Tags:#migrations#sqlite#encryption#drift#flutter#sqlcipher#daos
One-click install
npx skills add https://github.com/dimitriRemoiville/cc-mobile --skill drift-persistence
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: drift-persistence
Source: https://github.com/dimitriRemoiville/cc-mobile/tree/main/plugins/cc-mobile-flutter/skills/drift-persistence
Command: npx skills add https://github.com/dimitriRemoiville/cc-mobile --skill drift-persistence

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Encrypted, type-safe local databases are hard to manage across Flutter apps; drift-persistence provides patterns for schema definition, migrations, DAOs, and repository integration to keep data consistent and secure.

Core Features & Use Cases

  • Feature-focused schemas: Define per-feature tables and DAOs to keep data modular.
  • Migration-driven evolution: Centralized MigrationStrategy to evolve schema safely.
  • Encrypted storage: Use sqlcipher for offline data protection with a passphrase stored securely.

Quick Start

Initialize and migrate the Drift database with sqlcipher, define your tables and DAOs, and manage migrations as your schema evolves.

Frequently Asked Questions about drift-persistence

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

FAQPage Schema
How do I encrypt a local SQLite database in Flutter?▼

You can encrypt a local SQLite database in Flutter by combining drift with sqlcipher, using a securely stored passphrase to protect offline data while maintaining type-safe schema access.

What is the best way to manage database migrations in Flutter drift?▼

Managing drift migrations is best handled through a centralized MigrationStrategy, allowing you to safely evolve your schema and apply incremental changes as your app's features expand.

How do I structure feature-focused databases using drift DAOs?▼

You can structure feature-focused databases by defining per-feature drift tables and DAOs, keeping data modular and accessible through repository integration patterns.

Can I use sqlcipher with drift for secure local storage in Flutter?▼

Yes, sqlcipher works with drift to provide encrypted local storage, wrapping the SQLite database with passphrase-based encryption to secure structured offline data.

How do I test drift database migrations and DAOs in Flutter?▼

Testing drift database migrations and DAOs involves applying repository integration and test patterns to verify schema evolution and ensure data consistency across feature modules.

Related Skills

Explore More Software Engineering Skills→
martinholovskymartinholovsky
45

SQLCipher Encrypted Database Expert

Implement SQLCipher encrypted SQLite databases with Argon2id key derivation and OS keychain storage.

Community
Advanced
zakariafzakariaf

eng-add-persisted-model

Add Drift tables, DAOs, and repository transactions for new domain records in Flutter.

Community
Advanced
Probably-GroupProbably-Group
3

SQLCipher Encrypted Database Expert

Implement SQLCipher encrypted SQLite databases with secure key derivation and re-keying.

Official
Advanced
dangdungvndangdungvn

flutter-working-with-databases

Manage local data persistence in Flutter apps using SQLite.

Community
Advanced