# Connecting to a Database
The connection screen allows you to enter connection information for your database.
Note - Beekeeper Studio does not support unix socket connections for PSQL or MYSQL, only TCP connections.
# SSL
There are three ways to connect to a database with SSL
- Trust the server: Connect with SSL without providing your own certificate.
- Required Cert: Connect with SSL, provide your own certs, and disable
rejectUnauthorized
. - Verified Cert: Connect with SSL, provide your own certs, and enable
rejectUnauthorized
.
Here's a table of how the various sslmode
flags from command line clients map to Beekeeper:
sslmode | Turn on SSL? | rejectUnauthorized |
---|---|---|
disable | no | n/a |
allow | no | n/a |
prefer | no | n/a |
require | yes | false |
verify-ca | yes | false |
verify-full | yes | true |
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:
tables
will be suggested after typingfrom
orjoin
columns
will be suggested after typing a tablename, or table alias, followed by a period, egfilm.
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 Ctrl+Space
, or Cmd+Space
.
# 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 :variable
, or $1
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.
# Keyboard Shortcuts
# General Shortcuts
New Window Ctrl + Shift + N
New Tab Ctrl + T
Close Tab Ctrl + W
Format Query Ctrl + Shift + F
Run Query Ctrl + ↩
# Edit
Undo Ctrl + Z
Redo Shift + Ctrl + Z
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Select All Ctrl + A