Once you are connected to your database Beekeeper Studio allows you to open tabs to do the following things:
- SQL Editor: Write and execute SQL Queries (this is what tabs do by default)
- Table Explorer: View table contents
# SQL Editor
Writing SQL is such a fundamental part of interacting with a relational database that we put this functionality front and center.
You can use the SQL query tab to write, and run, SQL queries quickly and easily.
# Code Completion
We have tried to make our code completion useful but not intrusive.
Code suggestions will automatically appear in the following situations:
tableswill be suggested after typing
columnswill be suggested after typing a tablename, or table alias, followed by a period, eg
In these situations, Beekeeper will automatically resolve the correct table and column names for the entity you are querying.
Oh, you want to manually trigger code-suggestions? The default key combo is
# Run Contexts
If you like writing big long SQL scripts with multiple queries in the same editor pane (I know I do), you might want to only run a portion of your script at a time.
Beekeeper allows you to:
- Run everything (this is the default)
- Run only the 'current' query (Beekeeper highlights this query for you so you know what will run)
- Run only what you have selected.
# Query Parameters
You can parameterize your queries and Beekeeper will prompt you for values when you run it.
You can use two types of syntax
select * from table where foo = :one and bar = :two select * from table where foo = $1 and bar = $2
# Table Explorer
Click the little
open button next to a table name to open the table in a table-tab.
Now you can filter, sort, and explore your table data all day.