MySQL Query Studio

A lightweight MySQL client for Visual Studio Code. Connect to MySQL databases, browse schemas, write and execute queries, and view results — all without leaving your editor.

Features

Connection Management

• Add, edit, and delete MySQL connections
• Secure password storage using VS Code SecretStorage
• SSH tunnel support for remote servers
• SSL/TLS encryption

Schema Browser

• Tree view of databases, tables, views, procedures, functions, and triggers
• Column details with type, key, and nullable info
• Index and foreign key inspection

Query Editor

• Open SQL editors bound to specific connections
• Execute selected SQL or entire document
• Keyboard shortcut: Cmd+Enter (Mac) / Ctrl+Enter (Windows/Linux)
• SQL snippets for common statements

Results Panel

• View query results in a formatted table
• Multiple result set tabs for multi-statement queries
• Query timing and affected row counts
• Copy results to clipboard

Table Data Browser

• Browse table data with pagination
• Filter with WHERE clauses
• Sort by column headers
• Inline row editing (insert, update, delete)
• CSV export and import

Commands

Configuration