Schema, Object, and Data Tools
The Metadata panel organizes the objects returned by the active engine. Click Refresh after an external schema change, or use the workspace builders to generate engine-specific commands.
Browse and Inspect Tables
Open a table's menu to:
- Browse Data — Open a query tab with a page of table rows.
- View Structure — Inspect columns, indexes, foreign keys, and related catalog information supported by the engine.
- Modify Table — Generate statements for column, index, and foreign-key changes.
- Copy Qualified Name — Copy the correctly quoted database, schema, and table name.
Create or Modify a Table
Click the plus button in the Metadata header to open the table builder. Define columns, data types, NULL behavior, primary keys, and auto-increment settings. The modify-table workflow can add, alter, or drop columns and create or remove indexes and foreign keys. Builders generate dialect-aware SQL and let you open it in a query tab for review before applying it.
Database Objects
Open the Metadata more-actions menu for Create Database Object, Drop Database Object, or Database Objects. Available object types depend on the engine:
- PostgreSQL and SQL Server — Databases, schemas, views, procedures, functions, triggers, and sequences.
- MySQL — Databases, views, procedures, functions, and triggers.
- Oracle — Views, procedures, functions, triggers, and sequences.
- SQLite — Views and triggers.
- MongoDB — Views.
- Redis — Uses key tools instead of database objects or tables.
Edit Relational Rows and MongoDB Documents
When browsing a table or collection, use the result-grid actions to insert, edit, or delete data. SSH Bridge stages generated changes in a query tab so you can review the command before execution.
Redis Key Tools
Redis browsing uses cursor-based key scanning instead of relational pagination. Filter keys by pattern, inspect their type and value, and stage changes for strings, JSON, lists, sets, hashes, sorted sets, and streams. Key creation, rename, update, and delete operations are validated before their transaction is applied.
Users and Permissions
Select Users & Permissions to inspect supported security catalogs and generate Grant or Revoke statements. SQLite does not manage server users or permissions. Always review generated permission changes before execution.