QueryFlow is a pure Swift desktop app built around PostgreSQL as a first-class connector. SSL, multi-tab editing, schema-aware Claude AI, scheduled jobs.
QueryFlow uses the standard PostgreSQL wire protocol with libpq-compatible authentication. Add a connection with host, port (5432 default), database, username, and password. SSL mode is configurable: require for production, disable for local. Test the connection, and the schema explorer immediately loads every table and column in your database.
The left-side Explorer panel shows every schema as an expandable folder. Click a schema to see its tables. Click a table to see its columns with type chips (TEXT, INTEGER, JSONB, TIMESTAMPTZ, custom types). Click a column to insert the column name at your cursor. Right-click a table for an instant SELECT * FROM table LIMIT 100.
The editor is built on CodeMirror with Postgres syntax highlighting. Run at cursor with Command-R, run all statements with Command-Shift-R, format SQL with Command-Shift-F. Query history (Command-E) stores your last 500 queries with full-text search.
QueryFlow's Claude AI integration includes full Postgres awareness. Claude sees your schema, your latest query results, and your recent errors. Ask Claude to write a query against your users table joining to orders on user_id and it writes correct SQL using your actual column names.
After writing a Postgres query, click Schedule in the toolbar. Pick a trigger (daily 9 AM, every hour, custom cron), pick a destination (write back to Postgres, email the result, upload to S3, write to Google Sheets), click Save. The job runs locally on your Mac on whatever schedule you set.
Postgres tools that run in a browser have latency, lose tabs on refresh, and never feel like part of your Mac. JVM-based clients take seconds to launch and consume hundreds of megabytes. QueryFlow is pure Swift — launches instantly, respects your trackpad gestures, uses Liquid Glass surfaces that match macOS Tahoe.
Depends on your workflow. Postico is excellent for pure Postgres. TablePlus is broader. QueryFlow is the only Mac-native option that adds Claude AI, Python notebooks, and scheduled ETL on top of Postgres support.
Yes. When adding a Postgres connection, choose SSL Mode: require for production servers, disable for local development. QueryFlow uses the standard libpq connection model.
Yes. Click the + button next to your tab to open a new query tab. Each tab maintains its own SQL editor state. Tabs are auto-named from the FROM clause and restored on next launch.
Click the Explain button in the toolbar to run EXPLAIN against your query. QueryFlow shows the formatted execution plan with cost estimates, node types, and row estimates.
There are good free Postgres-specific clients but none match QueryFlow's combination of native Mac performance, multi-database support, schema-aware Claude AI, Flow Books, and scheduled ETL.
QueryFlow is on the Mac App Store with a 14-day free trial. Connect your Postgres database and run your first AI-assisted query in under 60 seconds.