Quick Reference
The interactive SQL editor inspired by my all-time favorite, SSMS.
- Cross platform
- Open source
- Supporting SQLite, PostgreSQL, MySQL, SQL Server
- Rich: Graphing, CSV, automatic column prefixing
The whole app is built on one SQL feature, CTE. Common table expressions, these let you break a large query into individual steps. You stack your steps together to form your complex queries.
There's no other editor built to take real advantage of this. Here's the shortlist of what that means: Tackle errors quickly since we light up which step is the cause of a problem. Go faster confidently by reusing steps without copy paste.
Design Your Workflow
Data Cynical hands you a couple tools you'll combine in clever ways to craft your personal toolbox. Out of the box you'll see your steps, aliases, raw query, also your scratchpads.
Tools
Below are the main components of your toolset. Use them all or ignore most. There's some capability overlap between features so you'll get extra comfortable using your favorites.
| Description | Tool |
|---|---|
| Text area for editing your query. | Raw Query |
| List of table name shorthands / steps your query can use. | References |
| Build upon earlier queries or split a large query into reusable parts. | Steps |
| View another table's data while editing a query. | Scratchpads |
| See live visualizations or summaries. | Graphs |