Global Search
Global Search allows you to find data across all tables in the connected database without writing individual queries.
Accessing Global Search
- Use the Command Palette (Cmd+Shift+P) and search for "Find in Database"
- Available from the menu bar
Search Interface
The Global Search window provides:
Search Bar
- Text field for entering search terms
- Cmd+Return to start the search
- Cancel button to abort an in-progress search
Search Options
| Option | Description |
|---|---|
| Case Sensitive | Toggle case-sensitive matching |
| Exact Match | Search for exact text (vs. contains) |
Requirements
- Must be connected to a database
- Search is disabled when no connection is active
- The search button is disabled when the search text is empty
How It Works
- Enter your search text
- Configure search options (case sensitivity, exact match)
- Click Search or press Cmd+Return
- Tablen searches across all tables in the current database
- Results are grouped by table name
Search Process
- The Global Search service iterates through all tables
- For each table, it searches all text-compatible columns
- A progress indicator shows which table is being searched
- Results are displayed as they are found
Search Results
Results are displayed in a scrollable list:
Result Information
Each result shows:
- Table name: Which table the match was found in
- Column name: Which column contains the match
- Row data: The matching row's content
- Match highlight: The matched text is highlighted
Navigating Results
- Click a result to view the full row
- Double-click to open the table in a new tab
- Results are grouped by table for easy navigation
Performance Considerations
- Global search scans all tables, which can be slow on large databases
- Use specific search terms to reduce result volume
- The search can be cancelled at any time
- Consider using the Quick Filter (Cmd+Option+F) for single-table searches instead
Empty State
When no results are found:
- A clear message indicates no matches
- Suggestions for modifying the search are displayed
Search Scope
The search covers:
- All tables visible in the schema browser
- All text-compatible columns (VARCHAR, TEXT, CHAR, etc.)
- Does not search binary or blob columns
- Searches the currently connected database only