# MySQL UI

> Browser-based MySQL admin tool for browsing, querying, and managing your databases.

## Docs

- [Connect to a MySQL server from your browser](https://docs.w22.dev/connecting/new-connection.md): Enter your host, port, username, and password to establish a live connection to any MySQL server directly from MySQL UI in your browser.
- [Save and reuse named MySQL server connections](https://docs.w22.dev/connecting/saved-connections.md): Store named MySQL connections in MySQL UI so you can reload credentials and reconnect to frequently used servers with a single click.
- [Browse tables and navigate paginated data](https://docs.w22.dev/data/browsing-tables.md): Switch between databases, find tables with the sidebar search, open a paginated row view with 50 rows per page, and track row counts in MySQL UI.
- [Add, edit, and delete table rows in MySQL UI](https://docs.w22.dev/data/editing-data.md): Insert new rows, edit individual cells by double-clicking, update entire records, and delete rows with a confirmation step in MySQL UI.
- [Filter, sort, and search table data in MySQL UI](https://docs.w22.dev/data/filtering-sorting.md): Sort any column ascending or descending, search across text fields, and apply multiple column filters with operators like LIKE and IS NULL in MySQL UI.
- [Write and run SQL queries with MySQL UI's editor](https://docs.w22.dev/data/sql-editor.md): Use MySQL UI's built-in SQL editor to write MySQL queries with syntax highlighting, execute them, view results, and revisit query history.
- [Export MySQL tables and databases as SQL dumps](https://docs.w22.dev/import-export/export-database.md): Download a .sql dump of any table or your entire database from MySQL UI, with options for structure only, data only, or structure and data combined.
- [Import a SQL file to restore or migrate data](https://docs.w22.dev/import-export/import-sql.md): Upload a .sql file into MySQL UI to restore a backup or seed a database, with a statement-by-statement result report after import completes.
- [MySQL UI: browser-based MySQL database manager](https://docs.w22.dev/introduction.md): MySQL UI is a web-based admin tool that lets you connect, browse, and manage MySQL databases from any browser — no installation required.
- [MySQL UI keyboard shortcuts and hotkeys](https://docs.w22.dev/keyboard-shortcuts.md): All keyboard shortcuts in MySQL UI: run queries with Ctrl+Enter, trigger data search with Enter, and open cell editing with a double-click.
- [Connect and explore data: MySQL UI quickstart](https://docs.w22.dev/quickstart.md): Connect to a MySQL server, browse tables, and run your first SQL query using MySQL UI's browser-based interface — no installation needed.
- [Create a new MySQL table without writing SQL](https://docs.w22.dev/schema/create-table.md): Use MySQL UI's visual table builder to define column names, data types, nullability, and primary keys, then create the table in one click.
- [Add, modify, and drop MySQL table columns](https://docs.w22.dev/schema/manage-columns.md): Add columns to an existing table, change a column's data type or nullability, and permanently remove columns from MySQL UI's Structure tab.
- [Rename, duplicate, truncate, and drop tables](https://docs.w22.dev/schema/table-operations.md): Rename, duplicate, truncate, or permanently drop a table using the overflow menu in MySQL UI's table toolbar — with a summary of each action's effects.
- [View MySQL table structure, indexes, and DDL](https://docs.w22.dev/schema/table-structure.md): Inspect column definitions, nullable constraints, key types, and indexes, and view the raw CREATE TABLE SQL in MySQL UI's Structure tab.
- [Troubleshoot connection and data issues in MySQL UI](https://docs.w22.dev/troubleshooting.md): Diagnose and fix connection refused errors, access denied messages, missing databases, import failures, and lost saved connections in MySQL UI.