Where things are
With a database open, the rail on the left lists its tools in three groups: Data, Inspect and Safety. Every database gets the same tools where it can. Each tool takes the database's own name for the idea, so the data browser is Tables on PostgreSQL, Firestore on Firebase and Keys on Redis. When a database lacks a tool, such as users on SQLite, the tool stays in the rail greyed out. Hover it to see why.
Data
| Tool | What it's for |
|---|---|
| Dashboard | Latest rows, counts and charts on one grid, refreshed every 30 seconds or live. Plugin widgets go here. |
| Tables, Firestore, Keys | Browse and edit rows, documents and keys. On SQL databases, view and change each table's structure. |
| Query Editor, Query Builder, Console | SQL and CQL, Firestore and MongoDB queries, or Redis commands. Save and share them. |
| Migrations | Change data and schema with a way back. Migration Studio on Firestore and MongoDB, ordered migration files elsewhere. |
| Flare Assistant | Describe a query and get it written. On SQL and Redis, it also explains, fixes and speeds up queries. |
| Authentication, Users, Roles | Sign in accounts on Firebase and Supabase. Elsewhere, the database's own users and roles. |
| Functions | Deployed functions, procedures and triggers. |
| Storage | Buckets and files on Firebase, S3, Supabase and MongoDB GridFS. |
Inspect
| Tool | What it's for |
|---|---|
| Schema | Tables and fields, and how they relate. |
| Rules, Policies | Security rules on Firebase, row level security policies on PostgreSQL and Supabase, grants and ACLs elsewhere. |
| Compare | Diff two environments, then bring SQL, Redis or S3 in line. |
Safety
| Tool | What it's for |
|---|---|
| Activity | Every change you've made, with undo where Flare can undo it exactly. |
| Backups | Back up any database, now or on a schedule, and restore. |
| Team | Roles and access for each environment, when you work in a team. |
Around the tools
- The connection list is where Flare opens. Connections are grouped by project and team folder, with New connection at the top and Settings at the bottom.
- Settings holds your account, sync, appearance (including plugin themes), updates, projects, environment access, teams and Plugins, where you find, install and update plugins.
- The command palette (Ctrl K or ⌘K) reaches all of it from the keyboard.
Some tools need a particular plan. The rail labels them with the plan's name, and flare.tools lists what each plan includes.