Skip to main content
SyneHQ’s Data Explorer provides an intuitive interface for browsing database schemas, exploring table structures, and understanding your data relationships. Navigate through your database with ease using our interactive sidebar and detailed metadata views. Data Explorer Interface

​
Schema and Table Explorer

  • Hierarchical Schema View
    • Lists all schemas and databases in an organized tree structure
    • Expandable schema nodes show contained tables (e.g., default, digital_product, ecommerce_retail)
    • Visual indicators for different object types (schemas, tables, views)
    • Collapsible sidebar for maximum workspace utilization
  • Interactive Table Navigation
    • Tables are expandable to reveal column details and data types
    • Click on table names to insert them directly into the query editor
    • Column names can be clicked to add them to your current query
    • Drag-and-drop functionality for building queries visually
  • Smart Search and Filtering
    • Real-time search to quickly locate specific tables or columns
    • Filter by schema, table type, or data type
    • Search across table names, column names, and descriptions
    • Recently accessed tables appear at the top for quick access

​
Table Metadata and Details

  • Comprehensive Schema Information
    • View complete table schema including column names, data types, and constraints
    • Primary key and foreign key relationships clearly displayed
    • Null/not-null constraints and default values shown
    • Index information and performance optimization hints
  • Data Preview and Sampling
    • Instant preview of table data without writing queries
    • Sample rows displayed to understand data structure and content
    • Data type validation and format examples
    • Row count and table size statistics
  • Relationship Mapping
    • Visual representation of foreign key relationships
    • Connected tables highlighted for easy navigation
    • Relationship cardinality (one-to-one, one-to-many, many-to-many)
    • Suggested join paths for complex queries

​
Advanced Exploration Features - Console tab

​
Column Analysis

  • Data Distribution
    • Unique value counts and null percentages
    • Min/max values for numeric columns
    • Most frequent values for categorical data
    • Data quality indicators and anomaly detection
  • Type Intelligence
    • Automatic data type detection and suggestions
    • Format patterns for dates, phone numbers, emails
    • Encoding detection for text fields
    • Numerical precision and scale information

​
Query Building Assistance

  • Visual Query Builder
    • Drag tables to create automatic join suggestions
    • Point-and-click column selection
    • Visual relationship mapping for complex joins
    • Query optimization recommendations
  • Template Generation
    • Common query patterns for each table
    • Sample SELECT, INSERT, UPDATE, DELETE statements
    • Aggregation templates based on column types
    • Best practice query structures
⌘I