Cross-platform MySQL client
made for developers.

Fast, stable and developer-friendly.
Astoria SQL Client is a fast, cross-platform desktop application for working with MySQL databases. Built primarily for developers, it makes it easy to browse data, write SQL, modify database structures, and import or export data.

Free to use Windows Linux
Astoria SQL Client query editor and results grid Astoria SQL Client query editor and results grid
EVERYDAY DATABASE WORK

The tools you need.
A workflow that stays focused.

Built for developers who want a clear, focused MySQL workflow without unnecessary complexity.

Powerful SQL editor

Write and run one or many queries with syntax highlighting, schema-aware suggestions and keyboard shortcuts.

Direct data editing

Add, update and remove records in the data grid. Choose auto-save or review pending changes before saving.

Flexible data transfer

Import SQL, CSV and spreadsheets. Export databases, tables, query results or selected records.

Your workspace, restored

Keep connections and tabs organized in workspaces, then return to the same context after restarting.

BROWSE, QUERY, EDIT

Work with your data,
your way.

Move naturally between a powerful query editor and visual tools for everyday database tasks.

Manage your database with ease

Browse data and manage columns, indexes, foreign keys, ENUM and SET values from a clear visual interface.

Editing a MySQL table structure in Astoria SQL Client Editing a MySQL table structure in Astoria SQL Client
Visual MySQL data filtersVisual MySQL data filters

Find the records you need

Build precise filters with SQL operators, preview the query and inspect results without writing it all by hand.

Schema-aware SQL autocomplete in Astoria SQL ClientSchema-aware SQL autocomplete in Astoria SQL Client

Write and execute SQL faster

Schema-aware autocomplete, multiple-query execution and interactive results keep you in flow.

CONNECTIONS YOU CAN TRUST

Secure by design.
Simple by default.

Save MySQL connections, use password or key-based SSH tunnels, and encrypt credentials stored on your computer.

  • SSH tunnel support
  • Master password protection
  • Credentials stored locally
Secure connection settings in Astoria SQL ClientSecure connection settings in Astoria SQL Client
DATA IN, DATA OUT

Move data without
the busywork.

Flexible tools for moving anything from a few selected records to a large database—without rebuilding your setup every time.

CSV
SQL
XLS
XLSX
ODS

Import with confidence

Bring in SQL, CSV and spreadsheet files with automatic format detection, data preview, column mapping and progress tracking for large imports.

Export exactly what you need

Export complete databases, selected tables, query results or individual records to SQL, CSV, XLSX and ODS.

Start with your preferred defaults

Choose the export options you use most often once, so every new export starts with the settings that fit your workflow.

DEVELOPER-FIRST WORKFLOW

Small details.
A smoother workflow.

Astoria SQL Client remembers your context, keeps common actions close at hand and removes friction from repetitive database work.

Pick up exactly where you left off

Each saved server currently acts as its own workspace. Astoria SQL Client remembers its open tabs and their order, so your project is ready when you return.

Keep development and production workflows clearly separated.
Switching between workspaces in Astoria SQL ClientSwitching between workspaces in Astoria SQL Client
Context menu for copying a value or generating an INSERT queryContext menu for copying a value or generating an INSERT query

Useful actions, right where you need them

Common database actions are one right-click away—from copying a single value to generating an INSERT statement.

Choosing a MySQL collation in Astoria SQL ClientChoosing a MySQL collation in Astoria SQL Client

Find the right collation in seconds

See collations used in the current database first, then filter the complete list with just a few characters.

Searching tables in Astoria SQL ClientSearching tables in Astoria SQL Client

Jump to any table

Filter long table lists instantly and keep the database object you need within reach.

GOOD TO KNOW

Frequently asked questions

Astoria SQL Client currently supports MySQL. Support for other database engines is not included yet.

The application is available for Windows and Linux.

Yes. Astoria SQL Client is currently free to use.

Connection details stay on your computer, and passwords can be encrypted and protected with a master password.

AVAILABLE FOR WINDOWS & LINUX

Your database.
Your workflow.

Download Astoria SQL Client and make everyday MySQL work feel lighter.

Beta · All current downloads are beta releases. Astoria SQL Client is under active development.Free to use