Desktop · Data Tools

Iris Data Studio

← Back to Applications

Overview

A Flutter desktop CSV editor built for game-development data — items, dialogue tables, stats. It's built around an immutable document model managed with Riverpod, a PlutoGrid spreadsheet view, MySQL bidirectional sync, and an integrated Iris assistant that operates on the open document through tool calls.

The editor is a full spreadsheet: open/import CSV/TSV/TXT, edit cells with a mirrored formula bar, add/remove/duplicate/move/reorder rows and columns, multi-row batch edits via a checkbox column, search & replace with highlighted matches, 50-level undo/redo, and auto-detected column-type validation that red-tints invalid cells. A visual Query Builder hides non-matching rows AutoFilter-style with type-aware AND/OR conditions, and filters can be saved as named views that persist per file.

On the database side it goes well past push/pull: a visual SQL SELECT builder with live preview loads results as the document and can persist them as real MySQL views; a Schema Browser introspects columns, foreign keys, and indexes and lets you add/drop PKs, indexes, and FKs or change a column's type — each previewing raw DDL behind a confirmation, with plain-language hints keyed on MySQL error codes; and a Join Builder composes two-table JOINs. Because CSV-pushed tables are all-TEXT, it transparently handles prefix indexes and VARCHAR promotion so keys actually work.

Video Demo

Iris Data Studio Demo

Tech Stack

FlutterRiverpodPlutoGridNode.jsFastifyWebSocketMySQL

Key Features

  • Open/import/export CSV, TSV, JSON, and SQL INSERT statements
  • Full editing: cells, rows, columns, drag-reorder, sort, 50-level undo/redo
  • Checkbox-driven multi-row batch edit, duplicate, move, and compare
  • Search & replace with highlighted current/other matches
  • Auto-detected column-type validation with invalid-cell tinting
  • Visual Query Builder filtering rows with AND/OR conditions
  • Saved views — named filters persisted per file
  • MySQL bidirectional sync plus a visual SQL SELECT builder
  • Schema Browser: inspect/add/drop PKs, indexes, FKs and change column types via previewed DDL
  • Join Builder for two-table JOINs, loadable as the document or saved as a MySQL view
  • Iris assistant with CSV and database tool calling over WebSocket