Black Lives Matter. Support the Equal Justice Initiative and read our statement here.
Beekeeper Studio

Beekeeper Studio

Open Source SQL Editor and Database Manager for Linux, Mac, and Windows.

Attention Existing MacOS, Windows, and AppImage users:

  • Automatic update functionality was broken before version 1.7.5. Please update manually from the releases section on the right. From 1.7.5 the app will automatically update (like it was supposed to).

Beekeeper Studio

Beekeeper Studio is a cross-platform SQL editor and database manager available for Linux, Mac, and Windows.

Beekeeper Studio is MIT licensed so it is free (libre) and free (gratis).

Download now from our website

Love Beekeeper Studio and want to help, but can't write code? We have some ideas for you.

Features

Top feature: It's smooth 🍫, fast 🏎, and you'll actually enjoy using it 🥰

  • Autocomplete SQL query editor with syntax highlighting
  • Tabbed interface, so you can multitask
  • Sort and filter table data to find just what you need
  • Sensible keyboard-shortcuts
  • Save queries for later
  • Query run-history, so you can find that one query you got working 3 days ago
  • Default dark theme

One of our frustrations with other open-source SQL editors and database managers is that they take a 'kitchen sink' approach to features, adding so many features that the UI becomes cluttered and hard to navigate. We wanted a good looking, open source SQL workbench that's powerful, but also easy to use. We couldn't find one, so we created it!

SQL Editing Demo

Beekeeper Studio supports connecting to the following databases:

  • SQLite
  • MySQL
  • MariaDB
  • Postgres
  • CockroachDB
  • SQL Server
  • Amazon Redshift

Installation

Download the latest release from the releases page, or from our website

Contributing to Beekeeper Studio

We love any community engagement. Even if you're complaining becuase you don't like something about the app!

Because building an inclusive and welcoming community is important to us, please follow our code of conduct as you engage with the project.

Starting the Dev version of Beekeeper Studio

Want to write some code and improve Beekeeper Studio? Getting set-up is easy on Mac, Linux, or Windows.

# First: Install NodeJS 12+, NPM, and Yarn
# ...

# 1. Fork the Beekeeper Studio Repo (click fork button at top right of this screen)
# 2. Check out your fork:
git clone git@github.com:<your-username>/beekeeper-studio.git beekeeper-studio
cd beekeeper-studio/
yarn install # installs dependencies

# Now you can start the app:
yarn run electron:serve ## the app will now start

Where to make changes?

Beekeeper Studio has two entry points:

  • background.js - this is the electron-side code that controls native things like showing windows.
  • main.js - this is the entry point for the Vue.js app. You can follow the Vue component breadcrumbs from App.vue to find the screen you need.

Generally we have two 'screens':

  • ConnectionInterface - connecting to a DB
  • CoreInterface - interacting with a database

How to submit a change?

  • Push your changes to your repository and open a Pull Request from our github page (this page)
  • Make sure to write some notes about what your change does! A gif is always welcome for visual changes.

Maintainer notes (casual readers can ignore this stuff)

Release Process

  1. Up the version number in package.json
  2. Replace build/release-notes.md with the latest release notes. Follow the format that is there.
  • run `git log ..HEAD --oneline | grep 'Merge pull' to find PRs merged
  1. Commit
  2. Push to master
  3. Create a tag git tag v<version>. It must start with a 'v'
  4. git push origin <tagname>
  • Now wait for the build/publish action to complete on Github
  1. Push the new release live
  • Go to the new 'draft' release on the releases tab of github, edit the notes, publish
  • Log into snapcraft.io, drag the uploaded release into the 'stable' channel for each architecture.

This should also publish the latest docs

Post Release:

  1. Copy release notes to a blog post, post on website
  2. Tweet link
  3. Share on LinkedIn
  4. Send to mailing list on SendInBlue

Big Thanks

Beekeeper Studio wouldn't exist without Sqlectron-core, the core database libraries from the (now unmaintained) Sqlectron project. Beekeeper Studio started as an experimental fork of that repository. A big thanks to @maxcnunes and the rest of the Sqlectron community.

not_used
Beekeeper Studio SQL Editor Dark Mode Interface Beekeeper Studio SQL Editor Dark Mode Interface
Beekeeper Studio SQL Editor Light Interface Beekeeper Studio SQL Editor Light Interface
Beekeeper Studio SQL Editor Connect To a Database Beekeeper Studio SQL Editor Connect To a Database
Beekeeper Studio SQL Editor View and Edit Tables Beekeeper Studio SQL Editor View and Edit Tables

Something missing? Edit this app.

Keyboard Shortcuts

Key Action
/ Focus the search bar
Esc Focus the search bar and cleans it
Select the next search result
Select the previous search result
Enter Open the selected search result
cmdEnter Ctrl+Enter Open the selected search result in a new tab