Beekeeper Studio - SQL Editor (Open Source and Free) - Full Walkthrough (V2.0)

A full walkthrough of Beekeeper Studio 2.0 SQL editor / database manager for MacOS, Windows, and Linux.
We support Postgres, MySQL, SQLite, SQL Server, Redshift, and more.

In this walkthrough:
- Connecting to a database
- Using SSH Tunnels and SSL to connect to a database

- Writing and running a SQL query
- Viewing and navigating database data, including foreign key lookups

- Adding and removing rows from a database table

- Editing database table rows
- Modifying table columns
- Modifying table indexes
- Modifying foreign keys (relations)
- Exporting table data to CSV, JSON, and SQL
- Exporting SQL query results to CSV, JSON, Excel, and SQL

[mahdinouira]

how is it an open source if it keeps asking me for a license?

[huynhkhaphi]

Didn't work with delimiter on MySQL, i was demanded to use queries on terminal instead.

[Angel-luls]

Bravo! I really love the project from the beginning I saw potential, and it has accompanied me throughout my learning and journeys. Great job!

[sebastianfabara]

How can I install the community edition? I was using the 14 day free ultimate trial and it just ran out and now im stuck :/ I dont know how to compile the community edition from github...

[minhazkhan]

this is no longer a open source editor

[caigner]

Ok, you got me interested in your app. I'll install it and try it. One question popped up immediately: Are there plans to implement an ER-diagram viewer? Possible with automatic table placement and ratsnesting of all the connections between tables? (Like in PCB development). That would be awesome!

[TakinProfit]

Just want to say that it is horrible marketing to click the pricing page on a site and it open the YouTube app! I just want to know the freakin price ! Literally going to buy tableplus now just because I don’t want to watch a full video just to find out how much this costs.

[prezlamen]

You did not count that different people have different eye sight - I cannot see content on your video.

[MicroFourThirdsCorner]

Excellent. I like the software. There's one thing that appears to be missing, which is a bit of a deal breaker for me, full database export and import.

We work with a company that has 5 databases used in conjunction with each other and I like to be able to click on all 5 databases and do a full SQL export (one file per table, one folder per database), and when needed, a full SQL import that covers all tables in all of the databases to recover to a known backup state. I can't find that here. Can you point me in the right direction?

[LizaTikhova]

Can you work with multiple databases simultaneously and is there a visual distinction between different databases and tables. For example, i have a prod and a test database with the same tables and i want to compare data. Is it something that can be done in Beekeeper studio?

[PhilipNewborough]

Love this software! You guys are killing it!

[dhanpalsingh]

error establishing connection kindly upload the video on same

[MartinsTalbergs]

Awesome! Are you open to allow us to embed hosts neovim into the sql editor window?

[SokolovSergeyS]

Awesome project! Was looking for decent linux client for some time. Is there any way to upload data from csv? Thanks.

[muhammadabiodunsulaiman]

I got the free license, however, I'm unable to activate the software as I keep getting an error about the "License Name". How do I get the license name? I have used my name and the name of the organization I'm affiliated with, but I am still unable to activate the application with my serial key. Kindly help with this

[aukenman]

Add some examples howto add / delete another DB for curr user, please or small button for it. Thanks

[pixel]

I really want to have this as my daily sql editor. I use Sql Server at work so how do I make a server connection if I only pass in Server Type (Database Engine), Server name (Desktop-2####), Authentication (Windows Authentication).

[oegoeg]

Moving from sql tab to the table tab for just one letter editing looks kd weird :-/

[unknowninfinium]

Help, i cannot connect. My connect button is grey and after i save i cannot access mysql, how do i start Mysql?

[Khang-ltgk]

Currently it's my favourite, but it would be hella better if supports ER datagram view. Good work, love it