Table Explorer
Browse tables, edit rows, view indexes, and understand relationships.
The Table Explorer is the heart of DBStudio's user experience. It provides a spreadsheet-like interface for your database tables, supporting SQLite, PostgreSQL, and MySQL.
Core Features
Data Browsing
- Infinite Scroll: Millions of rows feel responsive.
- Table Views: show the tables in the database.
- Editing: Edit rows in the table.
- Search: Full-text search across visible columns.
Inline Editing
Double-click any cell to edit data directly. Changes are validated against column constraints before saving.
Editing respects foreign key constraints. DBStudio will show detailed error messages for constraint violations.
Schema Information
Column Details
View metadata for each column:
- Type and length.
- Nullability.
- Default values.
- Foreign key references.
Indexes
See all indexes on a table:
| Index Name | Type | Columns |
|---|---|---|
pk_users_id | PRIMARY | id |
idx_users_email | UNIQUE | email |
idx_users_created | INDEX | created_at |
Relationships
Quickly see which tables reference this table (inbound) and which tables this table references (outbound).
Adding Tables
Create new tables directly from the Explorer:
- Right-click in the sidebar.
- Select New Table.
- Define columns and constraints.
- Click Create.
Usage
- Select a Connection in the sidebar.
- Tables are listed automatically.
- Click any table to open it in a tab.