Querious 3
The best MySQL tool for macOS
The best MySQL tool for macOS
Version 3 — Requires macOS 10.15 or later.
View, search, edit, import, export, build, configure, and monitor your MySQL and compatible databases easier than ever before. Querious is full-featured, fast, and made exclusively for macOS, so it feels and works exactly how a Mac app should.
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 and coloring), 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.
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 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.
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.
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.)
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.
See each query that Querious executes.
Add or remove users, and change permissions.
Glance at a general overview of info.
See how many and which queries are running on the server.
See a complete list of all scheduled SQL events.
Inspect and change session- and server-level variables.
Access a log of any errors MySQL reports.
Find out which queries are taking too long.
Advanced users have quick access to engine status.
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.
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.
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
After selecting which databases on which servers to compare, choose which types of schema objects to compare, and which aspects to ignore.
Step Two
Querious will compare the structure and show you the results. Select which differences to ignore.
Step Three
Finally, the synchronization script will be shown and can be executed to make the chosen changes applied to the source database.
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.