MYSQL IDE / FROM INPUT TO DATABASE

Good data startswith a clear path.

Turn files into mapped records, investigate the results and prepare your next change. A MySQL workspace for application developers and the DBAs who keep their databases working.

Try MySQL See the mapped workflow

14-day trialMySQL 8.0 / 8.4 LTSWindows desktop

inventory.xlsxTO inventory.products

FILE COLUMNMYSQL FIELD

SKUskuvarchar

Descriptiondescriptionvarchar

Pricepricedecimal

Example mapped inventory record: TX-401, Desk lamp, price 49.00.

Illustrative column mapping / example inventory data

Actual dark-mode MySQL import workspace with workbook columns mapped to inventory.products, preview records and validation controls. — Actual MySQL app / example data

INSIDE MySQL-dbHydrate

From the first column to the next query.

Bring an inventory file into MySQL, check its records and keep the query, structure and access tools close at hand.

Mapped Excel & CSV imports
MySQL SQL scripts
Editable table records
ER diagrams & design
Shadow schema rehearsal
Primary-key row comparison
Filtered copy & masking
User, host & activity tools

Explore the MySQL tools Compare license options

Workbook & CSV mappingDELIMITER-aware scriptsShadow-target rehearsalUser and host context

DATA PREPARATION, THEN EVERYTHING ELSE

Follow the data through MySQL.

Start with mapped input. Keep working with SQL, schema definitions, related records and permissions in the same desktop edition.

Ask the next question in SQL.

Investigate imported records in query tabs, revisit recent statements and export results as CSV or JSON. The SQL console also understands MySQL DELIMITER directives for scripts.

Query tabs & history
Execution time & row counts
CSV / JSON result export
Table keys & relationships

Actual dark-mode MySQL SQL console showing an inventory query and its returned SKU, description and price records.

Look inside the MySQL SQL console

Respect the way MySQL changes.

DDL can commit statement by statement. Select schema differences, inspect their SQL and rehearse on a shadow target before reviewing recovery information.

inventory.productsPROPOSED COLUMN

+ supplier_codevarchar(40)

DIFFERENCESSHADOWRECOVERY

A MySQL schema plan is not one automatically reversible transaction. Read the rehearsal warnings and recovery SQL.

Check the records, cell by cell.

Compare selected tables with common primary keys. Inspect changed and missing rows within the configured limit, then review generated synchronization SQL.

IDDEVELOPMENTUAT

40149.0045.00

40212.0012.00

Inspect MySQL row comparison

Map the incoming file.

Select a workbook sheet and header.
Map columns, fixed values or defaults.
Validate append or primary-key matching.

Open the mapping workspace

Understand the structure.

Inspect keys and related records.
Build ER diagrams of existing tables.
Design tables and links for SQL review.

Prepare a useful test set.

Select filtered and related rows.
Reuse masking rules and seeds.
Review triggers and generated columns.

Check access and activity.

Inspect user and host accounts.
Review supported grants and roles.
Follow active sessions and waiting locks.

PREPARE A WORKFLOW YOU CAN REPEAT

Less friction around MySQL work.

Practical defaults for repeat imports, development datasets and reviewed changes.

Reuse a carefully mapped starting point.

Keep the input columns, target fields and import behavior visible. Review validation before sending rows to the selected MySQL table.

Review a change with engine context.

Read the dependency-ordered schema plan, shadow rehearsal and recovery information. Target protection keeps the environment explicit before execution.

Keep a local, encrypted workspace.

Connect directly to your databases. Your saved workspace is encrypted with its master password and can auto-lock when you leave your desk.

Return to work you already understand.

Reopen useful query history, reuse copy and sync profiles and inspect recorded local runs. Use the CLI for supported compare, plan and apply tasks.

MySQL permissions govern each import and database change.Read the edition answers

MYSQL QUESTIONS, DIRECT ANSWERS

Know the input. Know the operation.

Understand import behavior, scripts, database access and the scope of the edition before choosing a workflow.

Review MySQL availability

What can I do in the dbHydrate MySQL IDE?

Import and validate mapped Excel or CSV data, run SQL, edit records, design ER diagrams, compare schemas and selected rows, copy masked data and inspect supported MySQL users, hosts, grants and database activity.

Can I match an imported file to existing MySQL rows?

Yes. Map the workbook or CSV columns, set fixed values or database defaults and validate the input. Supported import behavior includes append and matching existing primary keys with per-column update choices.

How are MySQL schema changes rehearsed?

MySQL DDL can commit individual statements. dbHydrate rehearses on a shadow target and shows warnings, snapshot information and generated recovery SQL. Review these before applying; a schema snapshot is not a table-data backup.

Does the MySQL SQL console understand DELIMITER?

Yes. MySQL DELIMITER directives are supported when executing scripts. The console also provides separate query tabs, recent history, timing, row counts and CSV or JSON result export.

Can I review user and host permissions?

Yes. Inspect supported MySQL user and host accounts, direct database and table grants and role membership. Supported password, login and TLS controls require appropriate database permissions and review.

Which MySQL versions and desktop packages are available?

The published catalog lists MySQL 8.0 / 8.4 LTS. Download packages: Windows x64 installer, Windows x64 portable. Use the current catalog when choosing a target version and installer.

What are the MySQL trial and license terms?

The published product trial is 14 days. Current billing options: Monthly: $10.95 every month; 1 year: $99 every year; 2 years: $148.50 every 2 years; 3 years: $207.90 every 3 years. Each seat allows 2 device(s) for this product. PostgreSQL, MySQL and SQL Server have separate edition licenses.

CONTINUE WITH ANOTHER EDITION

A different database in your stack?

Choose the product for the engine you connect to. Each edition brings its own syntax, permissions and schema-change behavior.

dbHydrate for PostgreSQL

Follow PostgreSQL relationships, review phased DDL and inspect supported login roles and grants.

Discover PostgreSQL

dbHydrate for SQL Server

Investigate T-SQL, inspect blocking and review SQL Server logins alongside database users.

Discover SQL Server

START WITH YOUR MYSQL DATA

Make your next import a better starting point.

Try the MySQL tools on a file, a query and a reviewed change from your own workflow. The available product trial is 14 days.

MySQL 8.0 / 8.4 LTS2 device(s) per seat for this edition

Try dbHydrate for MySQLWindows x64 installer / Windows x64 portableView MySQL licensing Choose an installer