Database Explorer for MySQL, PostgreSQL, Files, and S3

Browse databases, local files, and object storage in one tree. Inspect schemas, run SQL, compare targets, and edit rows inline before you change production workflows.

DBConvert Streams includes free IDE workflows. Add paid migration or CDC runs only when you need them.

Unified Connection Tree

Databases, local files, and S3 buckets appear side-by-side in one navigation tree.

Unified connection tree showing S3, MySQL, and PostgreSQL connections side by side

Databases

  • PostgreSQL and MySQL connections (Snowflake coming soon)
  • Browse schemas, tables, and views
  • Inspect columns, keys, and indexes
  • Run SQL with context-aware object navigation

Local Files

  • CSV, JSON, JSONL, and Parquet
  • Automatic schema inference
  • Compressed file support (gzip, zstd, bz2)

S3 / Object Storage

  • AWS S3, MinIO, DigitalOcean Spaces, and more
  • Browse buckets and object prefixes visually
  • Multiple authentication methods

Core Feature

Data Viewer and Editor

Browse, filter, and edit records from connected sources with the same grid workflow.

Data viewer with inline editing, add row, and batch delete

Explore

  • Paginated grid for tables, views, and files
  • Sort by any column, filter with conditions
  • Inline cell inspection for large text, JSON, and binary fields
  • Unified behavior across database and file-backed sources

Edit

  • Edit cells inline with type-aware input
  • Add and delete rows directly in the grid
  • Batch operations for bulk changes
  • Switch between table view and raw output

Only in DBConvert Streams

Cross-Database SQL

Run a single SQL query across databases and files — no ETL, no staging.

Cross-database SQL query joining MySQL, PostgreSQL, and CSV files in one query

Query Across Sources

  • JOIN tables across PostgreSQL and MySQL in one query
  • Combine database tables with local files or S3 data
  • UNION results from different database engines
  • Glob patterns to query file sets inline

SQL Console

  • Context-aware autocomplete for tables, columns, and functions
  • Multi-tab editor with query history
  • Reopen closed tabs with full context (Ctrl+Shift+T)
  • Export results to CSV, JSON, or Parquet
  • Syntax highlighting and error indicators

No ETL pipelines. No staging tables. Query live data across sources in real time. Learn more about Cross-Database SQL →

Schema and ER Diagrams

Inspect columns, keys, indexes, and DDL definitions. Visualize relationships with interactive ER diagrams.

Interactive ER diagram with relationship lines, legend, and diagram tools panel

Column Definitions

View detailed column information including data types, nullability, defaults, and constraints.

Primary and Foreign Keys

Examine table relationships, key constraints, and referential integrity rules.

Index Information

Review table indexes, their types, and configurations for performance analysis.

DDL Scripts

View the complete DDL definition of any database object — tables, views, and more.

Full interactive ER diagrams. Explore relationships with crow's foot notation, force-directed layout, and export to SVG, PNG, or PDF. Learn more about the ER Diagram Tool →

Files and Object Storage

Query CSV, JSON, Parquet, and S3 objects directly as tables.

Local Files

  • Automatic schema inference for CSV, JSON, JSONL, and Parquet
  • Transparent decompression: gzip, zstd, and bz2
  • Nested JSON analysis and automatic flattening
  • Hive-partitioned directory support
  • Glob patterns to query multiple files at once

S3 and Object Storage

  • Access key, IAM role, and anonymous authentication
  • Query Parquet, CSV, and JSON in-place — no download
  • Glob-based queries across object key patterns
  • Preview metadata and schema without full download
  • AWS S3, MinIO, DO Spaces, Backblaze B2, and more

Powered by DuckDB. Vectorized execution engine for fast analytical queries — even on large Parquet datasets across local files and S3.

Two-Pane Comparison

Open two data sources side by side to compare schemas, data, and structures visually.

  • Side-by-side data view for source and target
  • Synchronized scrolling across panes
  • Schema diff highlighting between connections
  • Compare database tables, files, and query results

Quick Export and Streams

Transition from analysis to migration — create a stream directly from the explorer.

  • Create a migration stream directly from the explorer
  • Select specific tables or columns to include
  • Export query results to CSV, JSON, or Parquet
  • Configure target connection and start immediately
Create stream from explorer view with column selection, export format, and target configuration

Install DBConvert Streams and inspect the real data first

Start with the built-in IDE workflows to browse schemas, run validation queries, compare environments, and review targets before you plan migration or CDC.

Add paid stream execution only when the workflow moves into migration or replication.

Read the Database Explorer docs