Implement Drift for type-safe SQLite storage in Flutter apps.
npx skills add https://github.com/MADTeacher/mad-agents-skills --skill flutter-drift
Please help me install this Agent Skill. Skill: flutter-drift Source: https://github.com/MADTeacher/mad-agents-skills/tree/main/flutter-drift Command: npx skills add https://github.com/MADTeacher/mad-agents-skills --skill flutter-drift
Flutter apps often need local, persistent storage with a robust API; Drift provides a SQLite-based solution with type-safe queries and reactive streams, but getting started and wiring codegen can be complex.
High-intent search queries and answers about installing and using this skill.
To set up type-safe local storage with Drift, add the drift and drift_flutter packages to your pubspec.yaml, define your database using the DriftDatabase annotation, and run build_runner code generation to create the data access classes.
Drift supports reactive queries by exposing streams that automatically emit new data when underlying SQLite tables change, allowing your Flutter UI to update in real time without manual refresh calls.
Drift works across Flutter mobile, web, and desktop platforms for offline local storage, using drift_flutter to handle platform-specific database initialization and file management via path_provider.
Drift manages SQLite schema migrations through its built-in migration strategy, allowing you to define step-by-step schema changes between database versions while preserving existing local data during app updates.
The best way to integrate Drift with Riverpod or Provider is to instantiate your generated AppDatabase and provide it through your chosen state management solution, enabling dependency injection and reactive UI updates.
Drift database code fails to compile before running build_runner because the type-safe query classes and data access methods do not exist yet; you must execute code generation to create the required source files.
yash-gargConfigure Flutter projects for internationalization with localization dependencies and l10n.yaml settings.
titabashGenerate type-safe Riverpod providers for Flutter using riverpod_annotation.
maxkishchenko2015Implement drift as a local SQLite persistence layer in Flutter apps.
abd0-omarImplements local SQLite databases in Flutter apps with type-safe queries.
