QueryFlow uses the Redshift Data API with IAM authentication — no VPC tunneling, no IP whitelisting. Schema-aware Claude AI, scheduled queries, and Python notebooks in one Swift app.
Traditional Redshift connectivity required a JDBC driver, direct TCP to the cluster endpoint, VPC tunneling, and security group whitelisting. QueryFlow skips all of that by using the Redshift Data API — Amazon's recommended modern access pattern. You authenticate with IAM credentials. No tunneling, no jump host, no IP whitelist.
Open the Connections panel, click Add, pick Redshift. Provide the cluster identifier (or workgroup for Redshift Serverless), the database name, the database user, the AWS region, and your IAM access key pair. Click Test Connection — within a second or two, the green Connected indicator appears and your schema loads.
Once connected, Claude AI sees every schema, every table, every column in your Redshift database. Ask Claude to write a query against your fact_orders table joined to dim_customers and it writes correct SQL with your actual column names. Ask why a Redshift query is slow and Claude analyzes the EXPLAIN output.
After your query is right, click Schedule. Pick a trigger — daily, hourly, every-15-minutes, custom cron. Pick a destination — write results back to Redshift as a new table, email a report, upload to S3, push to a Google Sheet. The job runs locally on your Mac at the scheduled time.
QueryFlow's Visual ETL pipeline builder lets you map a Redshift query result to a Salesforce object. Use the AI Map button to auto-match field names. Schedule the pipeline to run daily and your Salesforce stays current with your warehouse data automatically. This is the workflow that costs $500 to $5,000 per month with Hightouch or Census.
QueryFlow is pure Swift compiled to native Apple Silicon. JVM-based Redshift tools take 5-15 seconds to launch and consume hundreds of megabytes. QueryFlow launches in under a second and uses a fraction of the memory.
QueryFlow is the most modern native Mac client for Amazon Redshift, using the Redshift Data API for authentication. The official Redshift Query Editor v2 runs in a web browser. DataGrip and DBeaver support Redshift but are not native Mac apps.
QueryFlow uses the Redshift Data API (HTTP/HTTPS) with AWS IAM credentials. Create an IAM user with the AmazonRedshiftDataFullAccess policy, generate an access key, paste it into QueryFlow once. Credentials are stored encrypted in the macOS Keychain.
Yes. The Redshift Data API works with both provisioned clusters and Redshift Serverless workgroups. When adding the connection, provide your cluster identifier or workgroup name.
Yes. Any Redshift query can be scheduled to run on cron, interval, daily, weekly, or monthly schedules. The job runs locally on your Mac — no AWS Lambda, no EventBridge, no orchestration infrastructure.
QueryFlow is transparent to node type — it sends queries through the Redshift Data API and the cluster executes against whatever compute is provisioned. Performance depends on your Redshift cluster sizing, not QueryFlow.
QueryFlow is on the Mac App Store with a 14-day free trial. Connect Redshift with IAM credentials and run your first query in 60 seconds.