QueryFlow is a pure Swift desktop app built for MySQL on Mac. RDS, Aurora, PlanetScale, MariaDB, or local — all supported with the same connection model.
QueryFlow connects to MySQL using direct TCP — the same wire protocol Workbench uses, but with a native Swift client rather than a JVM application. Add the host (localhost, RDS endpoint, or any reachable IP), the port (3306 by default), the database name, username, and password. SSL is supported.
The Explorer panel shows your MySQL databases as expandable folders. Click a database to expand into its tables. Click a table to expand into its columns with type chips (VARCHAR, BIGINT, JSON, TIMESTAMP, ENUM). Click a column to insert just the column name at your cursor. Right-click a table for an instant SELECT * FROM table LIMIT 100 query.
When you connect to MySQL, Claude AI gains awareness of every table and column. Ask Claude to write a JOIN between your orders and customers tables and it writes valid MySQL with the correct column names. Ask Claude why a query is slow against MySQL and it analyzes the EXPLAIN output, recognizing MySQL-specific patterns like index usage and join algorithms.
After your MySQL query works, click Schedule in the toolbar. Pick a trigger (every hour, daily at 9 AM, custom cron). Pick a destination — write the results to S3 as a daily CSV export, email them, upload them via SFTP, or write them back to another MySQL database or Snowflake.
Click the Python tab below your SQL editor. Your MySQL result is already loaded as a pandas DataFrame named df. You can immediately filter, transform, plot, or write it elsewhere. Plotly charts render inline. Boto3 is pre-installed for AWS work. Pyarrow is pre-installed for Parquet exports.
If you only need basic MySQL administration and you are comfortable with the Workbench UI, sticking with it is reasonable. QueryFlow becomes the better choice when you want native Mac performance, Claude AI in the editor, Python notebooks integrated with SQL results, or scheduled ETL pipelines.
MySQL Workbench is the official Oracle MySQL client. On Mac it works but is widely considered slow and dated — the UI is Java-based and does not respect macOS conventions. QueryFlow is the native Mac alternative with a polished Swift UI.
Yes. Any MySQL-compatible database accessible via TCP works — local MySQL, RDS MySQL, Aurora MySQL, PlanetScale, MariaDB, and self-hosted instances.
Yes. The SQL editor supports the full MySQL dialect including JOINs, CTEs (in MySQL 8.0+), window functions, JSON column queries, and stored procedures.
QueryFlow executes any SQL MySQL accepts, including CALL statements for stored procedures. The schema explorer shows tables and columns but does not currently browse stored procedures separately.
Not in the current version. For databases behind firewalls, the recommended pattern is to expose them through a cloud VPN or jump host. SSH tunneling is on the roadmap.
QueryFlow is the modern Mac-native MySQL client. 14-day free trial, no credit card. Native Swift, instant launch, Claude AI built in.