Database Explorer for MySQL, PostgreSQL, Files, and S3

One workspace for databases, files, and object storage.

  • Browse schemas
  • Run SQL
  • Compare data
  • Edit rows inline
  • View ER diagrams

Free IDE workflows. Add paid migration or CDC runs only when you need them.

Install DBConvert Streams View Explorer Docs

A database explorer lets you browse schemas, run SQL, inspect rows, and edit data without writing scripts or switching between vendor-specific tools. It is the IDE workflow you use before you start moving data — to verify what is on the source, what already exists on the target, and whether the schema you assume is the schema you actually have.

DBConvert Streams puts databases, local files, and S3 buckets into the same connection tree. A PostgreSQL table, a CSV file, and a Parquet object in S3 open in the same grid, with the same SQL console and the same comparison view — so validating data does not depend on which storage layer it happens to live in.

See it in action

Edit table rows inline and preview data files — Parquet, CSV, JSON — directly in Data Explorer, no separate SQL client, no export step.

Prefer a guided version? Full Data Explorer walkthrough

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
  • Visual query plans for PostgreSQL, MySQL, and DuckDB-backed queries
  • Reopen closed tabs with full context (Ctrl+Shift+T)
  • Export results to CSV, JSON, or Parquet
  • Syntax highlighting and error indicators
Visual PostgreSQL query plan with selected Index Scan details

Visual query plans

Inspect PostgreSQL, MySQL, and DuckDB-backed plans in the same SQL Console. Use the Plan view for operator comparisons and selected-node details, then switch to Raw when you need the database output exactly as returned.

Read query plan docs

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

Related workflows

Where exploration goes next

Every next step starts from the connections you already added here.

Join across sources

The question stops fitting in one database. Write a single SQL query over Postgres, MySQL, files, and S3 — no exports in between.

Move the data

Validated the source? Turn it into a migration: snapshot transfer with schema conversion, progress tracked table by table.

Keep targets in sync

After the initial load, log-based CDC streams committed changes so the target never goes stale.

Bring your AI in

Claude, Cursor, and Copilot read the same connections and schemas over MCP — ask in plain language, get answers from live data.

FAQ

Technical questions

Do I need to install a separate database client?

No. The explorer is part of DBConvert Streams. Connections, schema browsing, SQL console, ER diagrams, and inline editing all live in the same workspace.

Is the explorer free?

Yes. Browsing, schema inspection, SQL console, ER diagrams, and inline editing are included with DBConvert Streams. Paid stream execution applies only when you start a migration or CDC run.

How does the explorer handle large tables?

Tables and query results are loaded in pages, not all at once. Sorting, filtering, and inline inspection work on the current page. For analytical queries, the SQL console executes through DuckDB and uses vectorized execution.

Can I inspect why a SQL query is slow?

Yes. The SQL Console can show visual query plans for supported engines, with compact operator tables, selected-node details, and the original Raw plan output when you need the database response exactly as returned.

Does data leave my environment?

No. Queries run in the local DBConvert Streams instance against your configured connections. Source data is not uploaded to any external service.

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.

Install DBConvert Streams Plan Migration or CDC
Read the Database Explorer docs