Data Search

Search for data across tables and views directly from the connection tree without writing SQL queries. The search feature supports multi-selection and works across all supported database types.

Quick Start

  1. Select tables or views in the DB Explorer

    • Single selection: Right-click any table or view
    • Multiple selection: Cmd/Ctrl+Click to select multiple items, then right-click

  2. Choose “Search…” from the context menu

  3. Enter your search term in the input box

  4. View results - Each table or view opens in its own tab with all matching rows

How It Works

The search automatically detects your search term type and searches appropriate columns:

  • Text columns: Searches all string columns for values containing your search term
  • Numeric columns: When you enter a number, searches numeric columns for exact matches
  • Date columns: When you enter a valid date, searches date and datetime columns for matching values

The search generates SQL queries with OR conditions for relational databases, and uses native search operations for NoSQL databases.

Select multiple tables and views (even from different connections) to search them all at once. Results open in separate tabs, and each result set can be independently edited and refreshed.