sqflite_dev
2.3.1, released 7 months ago by quiqqy.ai
Web-based SQLite workbench for debugging databases in Flutter and Dart apps.
What it does
Starts a local HTTP server providing a web-based SQLite workbench UI during development. Allows developers to inspect tables, execute queries, view database structure, edit data, and manage schema live from any browser.
AI-written summary of version 2.3.1, based on the package's README and metadata. Report an inaccuracy
Use it when
- You need to inspect and debug SQLite databases during Flutter or Dart app development.
- You want a MySQL Workbench-style browser interface to run queries and view table data on mobile or desktop apps.
Skip it when
- You are building production releases (must be kept out of production builds).
- Your app does not use SQLite databases.
Strengths
- Tab-based workspace supporting multiple databases and tables.
- Includes SQL autocomplete, syntax highlighting, and destructive query protection.
- Accessible from any browser on your local network via a built-in server.
Weaknesses
- Development-only tool requiring careful exclusion from production codebases.
- Relies on external browser access to view data.
Setup
- Kind
- Flutter widgets
- Effort
- Low
- Code generation
- No
- Direct dependencies
- 4
Add to dev_dependencies and call enableWorkbench() on your database instance.
import 'package:flutter/foundation.dart';
import 'package:sqflite/sqflite.dart';
import 'package:sqflite_dev/sqflite_dev.dart';
void main() async {
WidgetsFlutterBinding.ensureInitialized();
final db = await openDatabase('my_database.db');
db.enableWorkbench(
webDebug: !kReleaseMode,
webDebugPort: 8080,
);
runApp(MyApp());
}Alternatives
Packages that do the same job and could replace sqflite_dev.
- flutterpi_tool
A tool to make development and distribution of flutter-pi apps easier.
77Compare - webdev
A command-line tool for developing and deploying web applications with Dart.
85Compare - storage_view
Flutter widget to inspect and edit key‑value storage such as shared_preferences.
53Compare - pixel_perfect
Puts a semi-transparent design image over the developed layout to compare original design and code.
50Compare
Works with
Packages commonly used together with sqflite_dev: ones it builds on, ones built on it, and its own family.