MySQL Query Studio
The most feature-rich MySQL client for Visual Studio Code.
Connect, browse, query, export, generate code, monitor, and administer — everything you need, without leaving your editor.
Highlights
- 190+ commands covering connections, querying, schema management, exports, code generation, performance analysis, security, and server administration
- GUI Connection Wizard with SSL, SSH tunnel, and test-connection support
- Schema Tree with databases, tables, views, procedures, functions, triggers, and events, each with color-coded icons and object counts
- Rich Table Data Panel with inline editing, sorting, filtering, row selection, JSON viewer, and keyboard navigation
- Query Editor with autocomplete, formatting, EXPLAIN, profiling, snippets, and multi-result tabs
- 22 Code Generators for TypeScript, Go, Python, Java, C#, Rust, Sequelize, Prisma, Laravel, Zod, GraphQL, Protobuf, TypeORM, Django, Knex, Flask, Spring JPA, Rails, Express REST API, Mermaid ER, dbdiagram.io, and Markdown ER
- 12 Export Formats including CSV, JSON, XML, YAML, HTML, LaTeX, TSV, SQL INSERT, Markdown, schema-only, data-only, and filtered exports
- Performance Analysis with index usage, fragmentation, deadlocks, buffer pool, lock contention, and wait events
- Security Auditing including privilege audit, unused users, SSL status, and column-level privileges
- Data Quality Tools for null ratio audit, orphan records, duplicate detection, and tables without primary keys
- User Management to list, create, drop users, and manage grants and passwords
- Server Monitoring for connections, memory, handler stats, open files, and aborted connections
Table of Contents
Getting Started
1. Install
Search for MySQL Query Studio in the VS Code Extensions marketplace and click Install, or install from the command line:
code --install-extension apaya.mysql-query-studio
2. Add a Connection
- Open the MySQL panel in the Activity Bar (left sidebar).
- Click the + button at the top of the Connections tree.
- Fill in the connection form: host, port, user, password, and optionally a default database.
- (Optional) Enable SSH Tunnel or SSL/TLS and fill in the relevant fields.
- Click Test Connection to verify, then Save.
3. Browse and Query
- Click a connection to connect. Expand it to see databases, tables, views, procedures, functions, triggers, and events.
- Click a table to open the Table Data Panel and browse rows.
- Right-click any node for context-specific actions (export, generate code, drop, analyze, etc.).
- Right-click a connection or database and select New Query to open the Query Panel.
Passwords are stored securely via VS Code's built-in SecretStorage API and are never saved in plain-text configuration files.
The sidebar tree view is your primary navigation hub.
| Feature |
Description |
| Databases with expand/collapse |
Each connected server lists all databases; expand to see object groups |
| Object groups |
Tables, Views, Procedures, Functions, Triggers, and Events, each as a collapsible group |
| Object counts |
Each group label shows the count in parentheses, e.g., "Tables (15)" |
| Color-coded icons |
Tables (blue), Views (purple), Procedures (green), Functions (green), Triggers (orange), Events (yellow) |
| Click to view definitions |
Click a view, procedure, function, trigger, or event to see its formatted CREATE definition |
| Right-click context menus |
Every node type has a context menu with relevant actions |
| Auto-connect on startup |
Automatically reconnects to your last used connection when VS Code opens |
| Inline refresh |
Click the refresh icon on any schema or group node to reload its children |
Table Data Panel
Opens on the right side when you click a table in the sidebar. This is a full-featured data browser and editor.
| Feature |
Description |
| Run SQL queries |
Execute custom SQL with Ctrl+Enter (Windows/Linux) or Cmd+Enter (Mac) |
| Sort by column headers |
Click any column header to toggle ascending/descending sort |
| Inline cell editing |
Double-click a cell to edit its value in place; changes are saved via UPDATE |
| Delete rows |
Select rows and use the action button to delete (with confirmation) |
| Export CSV / JSON / SQL INSERT |
Export the current result set in your preferred format |
| Copy all data as TSV |
One-click copy of all visible data as tab-separated values |
| Page size selector |
Choose 25, 50, 100, 250, 500, or 1000 rows per page |
| WHERE clause filter |
Type a WHERE condition to filter rows (e.g., status = 'active') |
| Column visibility toggle |
Show or hide specific columns from the result grid |
| Resizable columns |
Drag column borders to resize |
| Column reordering |
Drag column headers to rearrange column order |
| Pinned first column |
The first column stays visible while scrolling horizontally |
| Row numbers |
Each row displays its sequence number |
| Zebra striping |
Alternating row colors for easier reading |
| Click cell to copy value |
Single-click a cell to copy its value to the clipboard |
| Full content tooltip |
Hover over a cell to see its full content in a tooltip |
| Checkbox row selection |
Select one or more rows using checkboxes for bulk actions |
| Distinct NULL highlighting |
NULL values are displayed with a distinct visual style |
| Row detail sidebar |
Click a row number to open a detail sidebar showing all column values |
| Add new row form |
Insert a new row using a structured form |
| Duplicate selected row |
Clone an existing row with one click |
| Bulk delete selected rows |
Delete multiple selected rows in a single operation |
| Undo last edit |
Revert the most recent cell edit |
| JSON cell viewer |
Auto-detects JSON content in cells; click to view formatted JSON |
| Number formatting |
Large numbers display with comma separators for readability |
| Go to specific page |
Jump directly to any page number |
| Arrow key navigation |
Navigate between cells using arrow keys |
| Ctrl+F find in visible data |
Search within the currently displayed data |
| Query execution time |
Displays how long each query took to execute |
| Selected rows count |
Shows the number of currently selected rows |
Query Panel
Opens on the right side from New Query. A dedicated SQL editor with rich result display.
| Feature |
Description |
| Run SQL |
Execute queries with Ctrl+Enter (Windows/Linux) or Cmd+Enter (Mac) |
| Format SQL |
Reformat your SQL with proper indentation and uppercase keywords |
| EXPLAIN |
Run EXPLAIN on your query with Ctrl+Shift+Enter |
| Export results as CSV/JSON |
Export the current result set |
| Copy results as TSV |
Copy result data as tab-separated values |
| Save query as snippet |
Save the current SQL as a named snippet for later reuse |
| Query history dropdown |
Browse and re-run from the last 50 executed queries |
| SQL keyword autocomplete |
Auto-suggests SQL keywords as you type |
| Ctrl+L clear results |
Clear the results panel |
| Sortable result columns |
Click column headers in results to sort |
| Search/filter within results |
Filter result rows by keyword |
| Resizable result columns |
Drag column borders to resize result columns |
| Row count and execution time |
Displayed per result set |
| Pagination with load more |
Large result sets are paginated with a load-more option |
| Click cell to copy value |
Single-click any result cell to copy its value |
| JSON cell viewer |
Auto-detects and formats JSON content in result cells |
| Export individual result tabs |
Export each result set independently |
| Multi-result tabs |
Multiple result sets (e.g., from stored procedures) display in separate tabs |
All Commands by Category
Every command is accessible from the Command Palette (Ctrl+Shift+P / Cmd+Shift+P) by typing its title. Many are also available via right-click context menus in the sidebar tree.
Connection Management
| Command |
Description |
MySQL: Add Connection |
Open the GUI connection wizard to add a new MySQL/MariaDB server |
MySQL: Edit Connection |
Reopen the connection wizard with existing settings pre-filled |
MySQL: Delete Connection |
Remove a saved connection profile and its stored password |
MySQL: Connect |
Connect to a disconnected server |
MySQL: Disconnect |
Close the active connection to a server |
MySQL: Duplicate Connection |
Create a copy of a connection profile for modification |
MySQL: Rename Connection |
Change the display name of a connection without altering host/port/user |
MySQL: Test Connection |
Attempt to connect and display the MySQL version on success |
MySQL: Connection Info |
Show version, uptime, threads, and total queries for the active connection |
MySQL: Generate Connection String |
Generate a connection string in MySQL URI, JDBC, .env, PHP PDO, or Python format and copy to clipboard |
MySQL: Select Database |
Switch the active database on a connected server |
MySQL: Refresh |
Refresh the schema tree or a specific node to pick up external changes |
Query & Execution
| Command |
Description |
MySQL: New Query |
Open a new query editor panel connected to the current server/database |
MySQL: Format SQL |
Format the selected SQL or entire document with proper indentation and uppercase keywords |
MySQL: EXPLAIN Query |
Run EXPLAIN on your SQL and display the execution plan |
MySQL: Run SQL from Clipboard |
Execute whatever SQL is currently on your clipboard and show results |
MySQL: Query History |
Browse and re-open previously executed queries (searchable) |
MySQL: Clear Query History |
Remove all saved query history entries |
MySQL: Query Profiling |
Execute SQL with profiling enabled and display a time breakdown |
MySQL: Show Warnings |
Display any warnings generated by the last executed query |
Saved Snippets
| Command |
Description |
MySQL: Save Query Snippet |
Save the selected SQL as a named snippet for later reuse |
MySQL: Load Query Snippet |
Pick from your saved snippets and open it in a new SQL document |
MySQL: Delete Snippet |
Select and remove a specific saved snippet |
MySQL: Clear All Snippets |
Remove all saved snippets after confirmation |
Schema Navigation & Search
| Command |
Description |
MySQL: Quick Open Object |
Fuzzy search across all tables, views, and routines in all databases; click to open |
MySQL: Search Across All Tables |
Enter a search term and scan every text column in every table for matches |
MySQL: Find Column by Name |
Search for column names across all tables; shows table, type, nullable, and key info |
MySQL: Go to Referenced Table |
Navigate from a foreign key to its referenced table's data browser |
MySQL: View Table Data |
Open the Table Data Panel for any table to browse its rows |
MySQL: Select Top N Rows |
Quick-select the first 10, 50, 100, 500, or 1000 rows from a table |
MySQL: Open in Query Editor |
Open a new query panel pre-connected to a specific table's schema |
Table Browsing & SQL Generation
| Command |
Description |
MySQL: Generate SELECT |
Generate a SELECT statement listing all columns explicitly |
MySQL: Generate INSERT Template |
Generate an INSERT statement with type-hint placeholders for each column |
MySQL: Generate UPDATE Template |
Generate an UPDATE with SET for non-PK columns and WHERE from PK columns |
MySQL: Generate DELETE Template |
Generate a DELETE with WHERE clause based on primary key columns |
MySQL: Generate SELECT COUNT |
Generate SELECT COUNT(*) FROM table |
MySQL: Generate SELECT DISTINCT |
Pick columns and generate a SELECT DISTINCT query |
MySQL: Generate SELECT with JOINs |
Auto-generate LEFT JOINs based on the table's foreign key relationships |
MySQL: Generate WHERE Clause |
Generate a WHERE clause from primary keys and copy to clipboard |
MySQL: Generate CRUD Statements |
Generate all four (SELECT, INSERT, UPDATE, DELETE) in one document |
Table Operations & Modification
| Command |
Description |
MySQL: Show CREATE TABLE |
Display the full CREATE TABLE DDL in a SQL document |
MySQL: Table Info |
Show engine, row count, data/index size, collation, timestamps, and comment |
MySQL: Show Table Partitions |
Display partition names, methods, expressions, row counts, and sizes |
MySQL: Table Status |
Show full SHOW TABLE STATUS output for a database |
MySQL: Show Column Count |
Display how many columns a table has |
MySQL: Show Full Column Details |
Show complete column metadata including collation and privileges |
MySQL: Show Table Dependencies |
Show which tables this table references and which tables reference it (FK graph) |
MySQL: Compare Table Structure |
Compare columns with another table; shows additions, removals, and type differences |
MySQL: Rename Table |
Rename a table via RENAME TABLE |
MySQL: Duplicate Table |
Duplicate a table's structure only or structure and data |
MySQL: Move Table to Database |
Move a table to a different schema on the same server |
MySQL: Copy Table to Database |
Copy a table's structure and data to another schema |
MySQL: Add Column |
Add a new column specifying name, type, nullable, and default value |
MySQL: Add Index |
Create a new index by selecting columns, choosing regular or unique, and naming it |
MySQL: Change Table Engine |
Switch between InnoDB, MyISAM, MEMORY, ARCHIVE, or CSV |
MySQL: Edit Table Comment |
Set or update the table-level comment |
MySQL: Change Auto-Increment |
Reset or set the AUTO_INCREMENT value for a table |
MySQL: Analyze Table |
Update index statistics for the query optimizer |
MySQL: Optimize Table |
Reclaim unused space and defragment the table |
MySQL: Check Table |
Check the table for errors |
MySQL: Repair Table |
Attempt to repair a corrupted table (MyISAM) |
MySQL: Truncate Table |
Remove all rows from a table (with confirmation) |
MySQL: Drop Table |
Drop the table entirely (with confirmation) |
MySQL: Show Table Row Counts |
List all tables in a schema sorted by approximate row count |
Column, Index & Foreign Key Operations
| Command |
Description |
MySQL: Drop Column |
Remove a column from a table (with confirmation) |
MySQL: Edit Column Comment |
Set or update a column-level comment |
MySQL: Drop Index |
Drop an index including PRIMARY KEY |
MySQL: Drop Foreign Key |
Remove a foreign key constraint |
View, Routine, Trigger & Event Operations
| Command |
Description |
MySQL: Show View Definition |
Display the CREATE VIEW statement for a view |
MySQL: Show Routine Definition |
Display the CREATE PROCEDURE or CREATE FUNCTION statement |
MySQL: Show Trigger Definition |
Display the CREATE TRIGGER statement |
MySQL: Show Event Definition |
Display the CREATE EVENT statement |
MySQL: Drop View |
Drop a view (with confirmation) |
MySQL: Drop Procedure |
Drop a stored procedure (with confirmation) |
MySQL: Drop Function |
Drop a stored function (with confirmation) |
MySQL: Drop Trigger |
Drop a trigger (with confirmation) |
MySQL: Drop Event |
Drop a scheduled event (with confirmation) |
Database Management
| Command |
Description |
MySQL: Create Database |
Create a new database/schema on the connected server |
MySQL: Drop Database |
Drop an entire database (with confirmation) |
MySQL: Rename Database |
Rename a database by creating a new one, moving all tables, and dropping the old one |
MySQL: Database Size |
Show table count, data size, index size, and total for a database |
MySQL: Show CREATE DATABASE |
Display the DDL for a database |
MySQL: Show Database Charset |
Show the default character set and collation for a database |
MySQL: Show All Indexes |
List every index in a database with table, columns, unique flag, and type |
MySQL: Table Size Dashboard |
Show all tables sorted by size with engine, rows, data/index breakdown |
MySQL: Table Checksums |
Compute and display checksums for all tables in a database |
MySQL: Schema Report |
Generate a comprehensive report with object counts, sizes, charset, and table listing |
MySQL: Check All Tables |
Run CHECK TABLE on every table in a database |
MySQL: Optimize All Tables |
Run OPTIMIZE TABLE on every table in a database |
MySQL: Show CREATE All Tables |
Display all CREATE TABLE statements in one document |
MySQL: Show CREATE All Views |
Display all CREATE VIEW statements in one document |
Export
| Command |
Description |
MySQL: Export as CSV |
Export all table rows as a .csv file |
MySQL: Export as JSON |
Export table data as a formatted .json file |
MySQL: Export as SQL INSERT |
Generate INSERT statements for all rows in a table |
MySQL: Export as XML |
Export table data in XML format |
MySQL: Export as YAML |
Export table data in YAML format |
MySQL: Export as HTML Table |
Export data as a styled HTML <table> |
MySQL: Export as LaTeX |
Generate a LaTeX tabular environment for academic papers |
MySQL: Export as TSV |
Export data as a tab-separated values file |
MySQL: Export as Markdown Table |
Export data as a Markdown table file |
MySQL: Export with WHERE Filter |
Export only rows matching a WHERE clause in CSV, JSON, or SQL format |
MySQL: Export Table Backup (DDL+Data) |
Export CREATE TABLE and INSERT data in one .sql file |
MySQL: Export Schema Only |
Export all CREATE TABLE statements for a database without data |
MySQL: Export Data Only |
Export INSERT statements for all tables without DDL |
MySQL: Export Database Dump |
Full schema dump including tables, views, routines, and triggers |
Import
| Command |
Description |
MySQL: Import SQL File |
Browse for a .sql file and execute it against the current connection |
MySQL: Import CSV to Table |
Select a CSV file and import rows into a table with column mapping |
Code Generation (Languages & Frameworks)
Right-click a table and choose the target language or framework. The generated code is opened in a new editor tab.
| Command |
Description |
MySQL: Generate TypeScript Interface |
Generate a TypeScript interface with mapped types (number, string, Date, boolean, Buffer) |
MySQL: Generate Go Struct |
Generate a Go struct with db/json tags and pointer types for nullable fields |
MySQL: Generate Python Dataclass |
Generate a Python @dataclass with Optional types and datetime imports |
MySQL: Generate Java JPA Entity |
Generate a JPA @Entity class with @Id, @GeneratedValue, and @Column annotations |
MySQL: Generate C# Entity |
Generate a C# class with [Key], [Column] attributes and nullable value types |
MySQL: Generate Rust Struct |
Generate a Rust struct with serde derives, Option<T> for nullable, and chrono for dates |
MySQL: Generate Sequelize Model |
Generate a Sequelize model definition with DataTypes, primaryKey, and autoIncrement |
MySQL: Generate Prisma Schema |
Generate a Prisma model block with mapped types, @id, and @default(autoincrement()) |
MySQL: Generate Laravel Migration |
Generate a Laravel migration class with Schema::create and column types |
MySQL: Generate Zod Schema |
Generate a Zod schema with z.object(), z.number(), z.string(), and .nullable() |
MySQL: Generate GraphQL Type |
Generate a GraphQL type definition with Query type for single and list operations |
MySQL: Generate REST API (Express) |
Generate full CRUD routes (GET, POST, PUT, DELETE) with parameterized queries |
MySQL: Generate Protobuf Message |
Generate a proto3 message with mapped scalar types |
MySQL: Generate TypeORM Entity |
Generate a TypeORM @Entity class with @PrimaryGeneratedColumn and @Column decorators |
MySQL: Generate Django Model |
Generate a Django models.Model subclass with CharField, IntegerField, DateTimeField, etc. |
MySQL: Generate Knex.js Migration |
Generate a Knex migration with createTable, column types, and nullable()/notNullable() |
MySQL: Generate Flask-SQLAlchemy Model |
Generate a Flask db.Model subclass with db.Column, db.String, and db.Integer |
MySQL: Generate Spring JPA Entity |
Generate a Spring @Entity class and JpaRepository interface with proper Java types |
MySQL: Generate Rails Migration |
Generate an ActiveRecord migration with create_table and Ruby column types |
SQL & Migration Generation
| Command |
Description |
MySQL: Generate DDL (IF NOT EXISTS) |
Generate CREATE TABLE with IF NOT EXISTS for safe re-execution |
MySQL: Generate INSERT from Data |
Read actual rows and generate INSERT statements (choose 10, 50, 100, or all rows) |
MySQL: Generate SQL Migration |
Generate up/down migration with CREATE TABLE and DROP TABLE IF EXISTS |
MySQL: Generate Stored Proc Template |
Generate INSERT and GET-by-PK stored procedure templates |
MySQL: Generate Trigger Template |
Generate BEFORE INSERT, BEFORE UPDATE, and AFTER DELETE trigger templates |
MySQL: Generate Event Template |
Generate recurring and one-time scheduled event templates |
Diagram Generation
| Command |
Description |
MySQL: Generate Mermaid ER Diagram |
Generate an ER diagram in Mermaid syntax showing all tables, columns, keys, and relationships |
MySQL: Generate dbdiagram.io DSL |
Generate schema in dbdiagram.io format to paste directly into dbdiagram.io |
MySQL: Generate Markdown ER |
Generate a Markdown document with table structures and FK relationships |
User & Privilege Management
| Command |
Description |
MySQL: List Users |
Show all MySQL users with their host values |
MySQL: Show User Grants |
Pick a user and display their GRANT statements |
MySQL: Show Grants |
Show grants for the currently connected user |
MySQL: Create User |
Create a new user with username, host (default %), and password |
MySQL: Drop User |
Select a user and drop them (with confirmation) |
MySQL: Change User Password |
Select a user and set a new password |
MySQL: Privilege Audit |
Show all user privileges from INFORMATION_SCHEMA |
MySQL: Show Unused Users |
List users who have never connected (requires performance_schema) |
MySQL: Column Privileges |
Show column-level grants on a table |
MySQL: Table Privileges |
Show table-level grants on a table |
| Command |
Description |
MySQL: Index Usage Statistics |
Show read/write counts per index from performance_schema |
MySQL: Show Redundant Indexes |
Find indexes that are subsets of other indexes |
MySQL: Show Fragmented Tables |
List tables with significant free space that could benefit from OPTIMIZE |
MySQL: Auto-Increment Headroom |
Show how close auto-increment columns are to their maximum values |
MySQL: Show Deadlock Info |
Extract the latest deadlock information from InnoDB status |
MySQL: Show Wait Events |
Show top wait events from performance_schema |
MySQL: Buffer Pool Statistics |
Show InnoDB buffer pool hit ratio, pages, and memory usage |
MySQL: Table Lock Contention |
Show tables with the most lock waits |
MySQL: InnoDB Status |
Display full SHOW ENGINE INNODB STATUS output |
Data Quality
| Command |
Description |
MySQL: Null Ratio Audit |
Scan all nullable columns and report the percentage of NULL values |
MySQL: Find Orphan Records |
Check each FK and report rows referencing non-existent parent rows |
MySQL: Find Duplicate Rows |
Pick columns to check and display groups of duplicates with counts |
MySQL: Tables Without Primary Key |
List tables missing a primary key (problematic for replication and performance) |
MySQL: Show Empty Tables |
List tables with zero rows |
MySQL: Data Freshness Report |
Show when each table was last updated and how many days stale |
| Command |
Description |
MySQL: Server Info |
Show version, uptime, charset, thread count, and total queries |
MySQL: Show Server Variables |
Browse all server configuration variables with optional filter |
MySQL: Global Status |
Browse all server status counters with optional filter |
MySQL: Show Storage Engines |
List all available storage engines and their support status |
MySQL: Show Character Sets |
List all supported character sets |
MySQL: Show Collations |
List all collations with optional filter |
MySQL: Show Open Tables |
List currently open tables with their lock status |
MySQL: SSL/TLS Status |
Show current SSL cipher, version, and certificate info |
MySQL: Replication Status |
Show replica/slave status for replication setups |
MySQL: Binary Logs |
List all binary log files with their sizes |
MySQL: Master/Binary Log Status |
Show binary log file and position for replication masters |
Server Monitoring
| Command |
Description |
MySQL: Connection vs Max |
Show current connections vs max_connections with percentage |
MySQL: Open Files vs Limit |
Show open file count vs open_files_limit |
MySQL: Memory Overview |
Show key memory-related server variables (buffer pool, sort buffer, etc.) |
MySQL: Handler Statistics |
Show Handler_* status counters for read, write, update, and delete operations |
MySQL: Aborted Connections |
Show counts of aborted connection attempts and client disconnects |
Server Administration
| Command |
Description |
MySQL: Show Process List |
View all running queries with user, host, time, and SQL text |
MySQL: Kill Process |
Select a running process from the list and terminate it |
MySQL: Set Global Variable |
Enter a variable name and new value (e.g., max_connections = 200) |
MySQL: Flush Tables |
Close all open tables and flush caches |
MySQL: Flush Privileges |
Reload the grant tables |
MySQL: Flush Binary Logs |
Close and reopen binary log files |
MySQL: Flush Status Counters |
Reset most server status counters to zero |
MySQL: Purge Binary Logs |
Remove binary logs older than a specified number of days |
Clipboard & Copy Utilities
| Command |
Description |
MySQL: Copy Name |
Copy the name of a table, view, column, procedure, function, trigger, or event to clipboard |
MySQL: Copy Qualified Name |
Copy the fully qualified name (`schema`.`table`) to clipboard |
MySQL: Copy Column List |
Copy all column names as a comma-separated list |
MySQL: Copy Row Count |
Run COUNT(*) on a table and copy the result to clipboard |
MySQL: Copy Structure as Markdown |
Copy a table's column definitions as a Markdown table |
MySQL: Copy Data as Markdown |
Copy the first 100 rows of a table as a Markdown table |
Keyboard Shortcuts
| Shortcut |
Action |
Context |
Ctrl+Enter / Cmd+Enter |
Run SQL query |
Table Data Panel or Query Panel |
Ctrl+Shift+Enter / Cmd+Shift+Enter |
EXPLAIN query |
Query Panel |
Ctrl+Shift+F / Cmd+Shift+F |
Format SQL |
SQL editor files |
Ctrl+L / Cmd+L |
Clear results |
Query Panel |
Ctrl+F / Cmd+F |
Find in visible data |
Table Data Panel |
| Arrow keys |
Navigate between cells |
Table Data Panel |
| Double-click |
Edit a cell inline |
Table Data Panel |
Configuration
All settings are under the mysqlQueryStudio namespace. Open Settings (Ctrl+, / Cmd+,) and search for "MySQL Query Studio".
| Setting |
Type |
Default |
Description |
mysqlQueryStudio.defaultRowLimit |
number |
200 |
Default LIMIT applied to SELECT queries |
mysqlQueryStudio.queryTimeout |
number |
30000 |
Query timeout in milliseconds |
mysqlQueryStudio.pageSize |
number |
100 |
Rows per page in the Table Data Panel |
mysqlQueryStudio.showSystemSchemas |
boolean |
false |
Show system schemas (mysql, information_schema, performance_schema, sys) in the tree |
mysqlQueryStudio.confirmDestructive |
boolean |
true |
Show confirmation dialog before DROP, TRUNCATE, and other destructive operations |
mysqlQueryStudio.connectionTimeout |
number |
10000 |
Connection timeout in milliseconds |
mysqlQueryStudio.queryHistorySize |
number |
100 |
Maximum number of queries to keep in history |
Requirements
- VS Code 1.85 or later
- MySQL 5.7+ or MariaDB 10.2+ server
- No external tools or binaries required -- the extension connects directly via the built-in
mysql2 driver
- SSH tunnel support requires an SSH server on the remote host
- SSL/TLS support requires appropriate CA, certificate, and key files if your server enforces them
Made by Apaya
| |
