Skip to content
pubscout

sqflite_dev

2.3.1, released 7 months ago by quiqqy.ai

Web-based SQLite workbench for debugging databases in Flutter and Dart apps.

$ flutter pub add sqflite_dev
Source repository

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.

  • webdev

    A command-line tool for developing and deploying web applications with Dart.

  • storage_view

    Flutter widget to inspect and edit key‑value storage such as shared_preferences.

  • pixel_perfect

    Puts a semi-transparent design image over the developed layout to compare original design and code.

Works with

Packages commonly used together with sqflite_dev: ones it builds on, ones built on it, and its own family.