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

1. Trust the server: Connect with SSL without providing your own certificate.
2. Required Cert: Connect with SSL, provide your own certs, and disable rejectUnauthorized.
3. 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:

1. SQL Editor: Write and execute SQL Queries (this is what tabs do by default)
2. 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 typing from or join
• columns will be suggested after typing a tablename, or table alias, followed by a period, eg film.

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:

1. Run everything (this is the default)
2. Run only the 'current' query (Beekeeper highlights this query for you so you know what will run)
3. 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.