TutorialApril 6, 2026

MySQL Browser Tutorial: Query & Browse Your MySQL Database from the Browser

Everything you need to get started with the DevToolSets MySQL Browser — connect to any MySQL server, explore tables, run queries, and save connections securely.

What You'll Learn

How to connect using a connection URL or individual fields
Browsing database tables and viewing their structure
Writing and executing SQL queries
Reading query results and performance timing
Using query history to re-run past statements
Saving encrypted credentials for quick reconnection

Prerequisites

Before you start, you'll need:

A running MySQL server (local or remote)
A database user with appropriate permissions
The connection details: host, port, username, password, and database name

Tip: For a quick test, a local MySQL instance with the default root user works fine.

Step 1: Connecting to Your Database

The MySQL Browser offers two connection modes.

Scheme mode (connection URL)

Paste a full MySQL connection string:

mysql://user:password@host:3306/dbname

Great when you already have a connection string from your hosting provider or .env file.

Standard mode (individual fields)

Fill in each field separately:

Host — defaults to localhost
Port — defaults to 3306
Username — your database user (e.g. root)
Password — the user's password
Database — the database to connect to

Open the MySQL Browser

Navigate to the MySQL Browser tool. You'll see the connection panel.

Choose your mode and fill in details

Toggle between Scheme and Standard using the tabs. Enter your credentials.

Click Connect

The tool tests the connection and loads your database tables. If successful, you'll see the connected view with a query editor and table browser.

Step 2: Browsing Tables

View the Tables tab

Once connected, the bottom panel shows a Tables tab listing all tables in your database. Each entry shows the table name, column count, and estimated row count.

Click a table to inspect it

Clicking a table name automatically runs a SELECT * FROM tablename LIMIT 200 query, showing you the data in the Results tab.

Step 3: Running SQL Queries

Write your SQL

The query editor is on the right side. It comes pre-filled with:

SELECT DATABASE(), USER(), VERSION();

Replace it with any SQL you want to run.

Execute

Click the Run button. The query is sent to your MySQL server and results appear in the bottom panel.

Read the results

The Results tab shows your query output in a table format with execution time displayed above. Errors show the full MySQL error message.

Example queries to try

SHOW TABLES;

DESCRIBE your_table;

SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();

SELECT @@version, @@datadir;

Step 4: Using Query History

Every query you run is saved to a local history (stored in IndexedDB, up to 20 entries).

How it works

Switch to the History tab in the bottom panel
Your recent queries are listed with timestamps
Click any entry to re-run it instantly
History persists across sessions in your browser
Older entries are automatically pruned when the limit is reached

Step 5: Customizing the Layout

The connected view uses a resizable split layout. Drag the dividers to adjust space:

Horizontal divider — adjust space between the connection info and query editor
Vertical divider — adjust space between the top panels and the bottom results area

Step 6: Saving Credentials for Quick Access

Save your connection details locally in your browser, encrypted with a PIN.

Check "Save credentials in browser"

On the connection form, tick the checkbox. Two new fields appear: a label and a master PIN.

Set a label and PIN

Give the connection a recognizable name (e.g. "Production MySQL" or "Local Dev"). Choose a 4-6 digit numeric PIN. Your credentials are encrypted with AES-256-GCM using a key derived via PBKDF2 and stored in IndexedDB.

Reconnect later

Next time you visit, your saved connections appear at the top. Click one, enter your PIN, and click Unlock — fields are filled in automatically.

Delete a saved connection anytime by clicking the ✕ button. Credentials never leave your browser.

Tips & Best Practices

Use a read-only database user when you only need to browse — prevents accidental data changes
Add LIMIT to your queries when exploring large tables
The execution time helps identify slow queries — use it to optimize
Connections are automatically cleaned up when you close the tab or navigate away
Query history is per-browser and stored locally — it won't sync across devices
For cloud databases (PlanetScale, AWS RDS, DigitalOcean, etc.), use the connection string from your provider's dashboard

Ready to try it out?

Open MySQL Browser →