In PopSQL, writing a query is easy, and there are a few ways to create and run your query.
Press the New Query button in the top left:
The keyboard shortcut for this is
Cmd+N on macOS, or
Ctrl+N on Windows/Linux.
Don't forget to name your query!
Right click on a folder and click
If you have multiple statements in one query separated by a semicolon, PopSQL will run the statement where your cursor is.
You can also highlight part of your query and PopSQL will run that part only.
To run your query, hit
Cmd+Enter on macOS, or
Ctrl+Enter on Windows/Linux, or hit the green
Run button in the top right of the app.
By default, we'll add a
limit 100 to your query so you don't accidentally run an expensive query. You can disable this by unchecking the checkbox, or by providing your own
You can also add a description to your query like this:
Premium Team users have unlimited version history on their SQL queries.