Querious is a MySQL database management application written from the ground up for Mac OS X. Unlike mindless Mac OS X ports of applications originally made for Windows or Linux, Querious works the way you'd naturally expect it to as a Mac OS X app. Querious is precise and easy to understand, giving you full control without getting in your way.
Viewing, searching, editing, importing, exporting, and structuring your MySQL databases has never been so easy. With Querious, you can even open up raw CSV or Tab files in a spreadsheet-like document. Need to rename or reorder the columns? No problem. Searching for data is a breeze, and you can even convert the whole file to another format in a snap!
What's New — Querious 1.1 optimizes the foundations laid in the first release. Connection handling is faster and more resistant to dropped connections. The main connection window tabs has also been rewritten, not only allowing tab reordering and dragging tabs between windows, but also allowing connections to different servers within the same window. Additionally, version 1.1 improves importing and exporting performance, performing nearly twice as fast, while also using less memory. All of these enhancements improve the usability, flexibility, and performance of Querious.
Data security is paramount these days, and that's why Querious supports direct connections to MySQL over SSL and SSH tunneling using password or key authentication right out of the box.
Viewing and editing table content with Querious is a breeze. Use the filter controls at the top of the view to focus on only the rows you need to see, using half-a-dozen logical operators, or a custom WHERE clause.
Querious has a great interface for defining table columns. Its straightforward and uncluttered design allows you to quickly see the table structure at a glance.
Indexes and Keys
Unlike other programs which simply show table indexes and keys as they are stored directly in the database, Querious shows them logically, so you don't have to understand the internal organization of the database management system.
Check out some basic table information, set the storage engine type, string encoding defaults, and any documentation. Querious doesn't leave out the basics.
Perform custom queries, taking advantage of syntax coloring and autocomplete, to do anything you want. Create tables, check user permissions, or perform a complex multi-join query when a simple search just won't do.
Managing user privileges "by hand" can be a pain. With Querious, you can effortlessly see and understand the privileges set for each user. Add and remove database-, table-, and even column-level privileges by simply clicking on checkboxes.
Import and Export
Querious can import and export data using SQL, CSV, and Tab files, allowing fine-tuned adjustments to adapt to any slight format differences between programs. Querious also has a unique interface for mapping columns in CSV and Tab files to columns in your database tables, so you can selectively import or export specific columns.
Why type the same queries over and over? Querious lets you store and organize queries right inside of the custom query view. It even intelligently remembers the successful queries you've run in the past.
Copy to the Clipboard
Need a quick way to get CSV formatted rows into another program? No problem. Querious lets you copy rows as CSV, Tab, or SQL for quick and easy transport between various programs.