MySQL Pro Client

The all-in-one MySQL client for Visual Studio Code

Built by OpSET México

MySQL Pro Client hero

One workspace. Your complete MySQL workflow.

Query	Model	Optimize	Manage
Smart SQL Editor	ER Diagrams	Visual EXPLAIN	Data Editor
Query Results	SQL → ER	Schema Compare	Table Designer
History & Favorites	Live ER Preview	Safety Controls	Backup / Restore
Stored Routines	FK Visualization	Migration SQL	CSV / JSON Import

⚡ Smart Batch Execution & Action Output

Run complete SQL scripts without flooding your VS Code workspace with one tab per DDL/DML statement.

Multi-statement CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, USE and other non-row commands are consolidated into a single Action Output panel.
Row-producing statements still open dedicated Query Results tabs.
Action Output tracks statement number, status, command, rows affected/returned, execution time and the exact failing statement.
Batch execution stops on SQL errors or cancelled mutation-safety prompts while preserving the completed execution log.
Copy the SQL for any logged statement directly from Action Output.

⚡ Query without leaving VS Code

Query Editor and Results

Run the current statement, a selection, or the complete SQL document. Use contextual IntelliSense, CodeLens, multiple result sets, Smart Filters and CSV/JSON export.

🧬 Turn schemas into diagrams

ER Diagram

Generate ER diagrams from a live MySQL database, parse DDL without executing it, or open a Live SQL → ER Preview while typing.

▶️ Execute Stored Procedures visually

Execute Procedure

MySQL Pro Client detects IN, OUT and INOUT parameters automatically from MySQL metadata.

Stored Procedure Results

Multiple result sets and output parameters are displayed together with execution time.

🔄 Compare environments

Schema Compare

Compare Reference → Target, identify additive, changed and destructive differences, then open Migration SQL for review. Migrations are never auto-applied.

🔍 Understand query plans

Visual EXPLAIN

Explore access types, indexes, estimated rows, costs, conditions and diagnostic warnings visually.

🛠️ Design tables visually

Table Designer

Edit columns, indexes, foreign keys, engine, charset and collation. Review generated SQL before applying changes.

💾 Backup / Restore

Backup and Restore

Use MySQL's official CLI tools with preview, tool discovery and reinforced confirmation for destructive operations.

🛡️ Safety by Design

SecretStorage for saved passwords.
Strong warning for UPDATE / DELETE without top-level WHERE.
Typed confirmation for DROP TABLE.
Conservative reconnect behavior.
Query row limits with explicit unlimited mode.
SQL Preview before Table Designer changes.
Migration SQL review before Schema Compare changes.
CSP + cryptographic nonce in WebViews.

🚀 Quick Start

Install MySQL Pro Client from Visual Studio Code Marketplace.
Add a connection.
Connect to MySQL.
Open a .sql file.
Use Ctrl/Cmd + Enter.

📚 Guides

OpSET México

Built for developers. Designed for productivity.