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, Collections on MongoDB and Keys on Redis. A few tools a database cannot have stay in the rail greyed out, such as Users and Rules on SQLite, and hovering one says why.
Data
| Tool | What it's for |
|---|---|
| Dashboard | Latest rows, counts and charts on one grid, read again every 30 seconds while it is open. Plugin widgets go here. |
| Tables, Firestore, Collections, Keys | Browse and edit rows, documents and keys. On SQL databases, Cassandra and MongoDB, view and change each table's or collection'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 on the rest, MongoDB included. |
| 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, and ACL users on Redis. |
| 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, Grants | Security rules on Firebase, row level security policies on PostgreSQL and Supabase, grants on MySQL, roles on MongoDB, permissions on Cassandra and ACL rules on Redis. |
| 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. Sync, teams and plans has more. |
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. They stay in the rail, labelled with the first plan that has them, and choosing one says what that plan adds. flare.tools lists what each plan includes.