QueryFolio

A SQL client that handles everything from MySQL and PostgreSQL to Redis, Elasticsearch, and DynamoDB in one app.

No more switching apps per data store. The editor language and the unit of execution change per engine, and features an engine lacks are hidden from the UI rather than left as dead buttons.

Features

• Connects to MySQL / PostgreSQL / SQLite / DuckDB / Redis / Elasticsearch / DynamoDB (PartiQL)
• CodeMirror 6 editor — run the statement under the cursor with Cmd+Enter, autocomplete table and column names, and format SELECT statements
• Guards that keep you from breaking a production database. Per-connection readonly rejects INSERT / UPDATE / DELETE / DDL, SELECTs without a LIMIT get one automatically (default 500), and destructive commands such as FLUSHALL or _delete_by_query are blocked
• SSH tunnel with known_hosts verification. Connections are configured in YAML, and secrets can stay out of the file — they are fetched lazily from 1Password through a getter command such as op read "op://..."
• OpenAI integration — generate SQL from natural language, fix failing queries, and analyze EXPLAIN plans with index suggestions. Generated SQL is inserted into the editor and never auto-executed. Only the schema, dialect, statements, and plans are sent; query results never are
• Query files are auto-saved per connection as plain .sql, alongside a searchable local execution history

Requirements & notes

• The macOS build is a universal binary (Intel / Apple Silicon). It is signed with a Developer ID certificate and notarized by Apple, so Gatekeeper does not warn.
• The Windows build is an x64 installer. It is not code signed, so SmartScreen shows a warning — choose "More info" then "Run anyway".
• Open source under the MIT License.