Querious - The best MySQL Tool for macOS

Table Content

It begins with a solid foundation.

The Content view is packed full of convenient features, such as a flexible multiple-condition filter, easy multi-row value assignment, row duplication, copying to the clipboard, and jumping to related tables through foreign keys.

Convenient Filtering

Easily build a multi-condition filter to find just the right records you want to look at. You can even copy the resulting SELECT statement.

JSON, Binary, Checkboxes

Edit values as text, JSON (with full syntax validation, coloring, and formatting), binary, or even as a simple checkbox for "boolean" columns, such as `tinyint(1)`

Foreign Keys

When a table contains foreign keys, click on the arrow next to a foreign key id value to immediately jump to the related records.

Vertical Editor

Have a table with a ton of columns? No problem. A "vertical editor" in the sidebar (with two different layouts) allows you view and edit table rows in a more form-like manner.

Conditional Highlighting

Customize the display to your display. Use a field value condition to set the field's or row's text color or background color. Understand your data at a glance.

Multi-Column Sorting

Visually see and control the sort order of multiple columns at a time with a simple click. Sorting happens at the server, without writing a query.

Editors for Everything

Fewer queries means greater efficiency.

Other database programs will have a good editor for viewing table contents and querying, but then completely fall short when supporting other object types. Querious goes all the way, providing thoughtfully-crafted editors for everything you need.

Avoid Writing Queries

Straightforward and uncluttered editors allow you to quickly see and change the structure make-up of your databases without having to write queries.

Editors for ALL Types

Complete interfaces for defining and editing table columns, indexes, primary and foreign keys, triggers, events, functions, and procedures. Querious doesn't simply stop at table contents.

A MySQL Assistant

The various editors in Querious are a great way to expand your knowledge of MySQL by learning what's available and making it easy to use and change.

Call Functions & Procedures

Setup function and procedure parameters, and even easily call procedures without having to use a query.

Triggers

Set up SQL code to run either before or after any insert/update/delete occurs in a table.

Events

Events are SQL code scheduled to run at either a specific time or on a reoccurring interval.

Import, Export, Duplication

It literally doesn't get any better.

Export Entire Server

Export anything from a single table to multiple databases at a time. You can even export the entire server's contents for a complete backup.

Export Presets

Exporting the same set of tables/databases/etc often? Save your export settings as a preset and easily reuse them over and over to save time.

Import Defaults

When importing CSV or Tab, specify default values to use for unmapped or empty columns.

Multiple Formats

Import or Export SQL, CSV, and Tab files, with fine-tuned adjustments to adapt to any slight format differences between programs.

Compressed Files

Big data? Small files. Querious can directly export to and import from compressed .gz files for maximum space savings.

Create Tables on Import

When importing a CSV or Tab file, you can create a new table directly from the imported data, specifying field names and types.

Not only can Querious do speedy imports and exports, but it can also "duplicate" views, triggers, functions, procedures, events, and even tables including their data content, within the same database, between databases on the same server, or between completely different servers! What's even more impressive is Querious can duplicate an entire database, even between servers.

Outstanding Performance

We hate waiting, and we know you do too. That's why we obsessed over shaving off every last microsecond wherever we could.

For example, when it comes to importing and exporting data, nothing is faster than Querious. The only reason to use anything besides Querious is if you actually like waiting for super-long exports.

(With performance this good, it's hard not to brag.)

Custom Querying

Advanced custom querying is richly supported when you need to perform custom joins, subselects, run alter statements manually, or any other kind of query. Context-sensitive autocomplete suggests just the right things at the right time, to make writing queries even faster.

Syntax Highlighting

Fast syntax highlighting of SQL keywords, values, and identifiers. Choose among multiple themes, with can even adapt to macOS Dark Mode.

Context-Sensitive Autocomplete

Autocomplete of MySQL keywords, database names, table/view/function/etc names, and even column names, with context-aware suggestions.

Multiple Code Editors

Open as many independent query tabs (code editors) as you want, each with independent results.

Organize Saved Queries

Convenient "Favorites" bar for often-used queries, and a highly organizable sidebar for big collections of queries.

Query Reformatting

Keep your code clean, with re-indented and case-corrected reformatting. You can even minify your SQL to embed in code.

Table Reference

Use the handy sidebar for referencing column names and types in tables.

Server Management

Going one step further.

Querious goes beyond just helping you manage the data in your tables by enabling you to quickly see the status of the server, such as bandwidth used, number of connections, and see the queries/processes running on the server. You can also setup and administer user permissions, the event scheduler, server variables, and when file system access is authorized (via SSH for remote hosts), Querious can even display the errors and slow queries logged on the server.

Query Transcript

See each query that Querious executes.

Users

Add or remove users, and change permissions.

Server Status

Glance at a general overview of info.

Processes

See how many and which queries are running on the server.

Events

See a complete list of all scheduled SQL events.

Server Variables

Inspect and change session- and server-level variables.

Error Log

Access a log of any errors MySQL reports.

Slow Query Log

Find out which queries are taking too long.

InnoDB Status

Advanced users have quick access to engine status.

User Management

A full-featured super-easy-to-user Users view makes adding and removing users, and changing their global, database-level, or even field-level privileges a cinch.

Table Relationships

Understanding at a glance.

Get a high level overview of how your tables are related to each other, and the keys which establish those relationships. See how tables connect to each other from foreign key to primary key.

Artificial Keys

Only in Querious can you specify artificial keys which relate two tables, mimicking PK/FK relationships, without modifying the database.

Export as PDF

The Relationships graph view can even be exported as a PDF for you to include in documentation.

Zoom, Fields & Types

Zoom in and out, show and hide field names and types. You can even hide tables with no connections.

Database Structure Comparison

Find and synchronize the differences.

When working with evolving database structure, sometimes the development and production environments can drift apart. With database structure comparison in Querious, you can compare two databases, find all of the differences between them, and even adopt the changes needed to make them the same.

Step One — Setup

After selecting which databases on which servers to compare, choose which types of schema objects to compare, and which aspects to ignore.

Step Two — Review

Querious will compare the structure and show you the results. Select which differences to ignore.

Step Three — Update

Finally, the synchronization script will be shown and can be executed to make the chosen changes applied to the source database.

Data File Editor

Edit CSV and Tab files easier than ever.

Querious has a powerful built-in editor for directly editing CSV and Tab files like a spreadsheet. If a client gives you a CSV file with wacky columns or malformed data, you can easily clean it up Querious.

Need to apply a regular expression replacement to all or just one column? You can! Need to join multiple columns together? Not a problem! Need to split a single column into multiple columns? That's no problem either! Not only can you easily manipulate the add, filter, and massage the data in the files, but converting between CSV/Tab format varitions is a cinch.

Process

Copy rows with unique values to a new document, or remove duplicates.

Split

Split a single column into multiple columns based on a given separator.

Join

Join multiple columns into a single column, with values separated by a separator.

Querious 4

A MySQL client you'll love, not fight.