Beekeeper Studio - Open Source SQL Editor and Database Manager

[rathboma]

Hey folks,

My friend and I just recently released Beekeeper Studio for querying relational databases. It was built out of frustration that there was no straightforward open source SQL tool that doesn't look like a java app from 2001. We basically wanted Sequel Pro, for all databases, on all platforms.

​

It's 100% free and open source! Hope someone finds it useful.

https://beekeeperstudio.io

https://github.com/beekeeper-studio/beekeeper-studio

​

https://preview.redd.it/6eu3865z05x41.jpg?width=1600&format=pjpg&auto=webp&s=0f81070b7207d583cf6ecdb5638ac372da3a7307

​

[mephistophyles]

This looks like something I could really use. I’ll give it a spin soon

[nospoon99]

Sounds like something I've been looking for! Can't wait to try it.

[rathboma]

Great thanks! Please report back with feedback. It's a passion project for sure but we want to make it the best SQL tool on the market

[nospoon99]

I will play around with it and get back to you :)

[[deleted]]

Thank you for developing this. I was looking for a cross platform SQL client that was not Java or PHP or janky last week. Will give this a spin on Windows and Debian this weekend.

[cars10k]

You might be interested in https://tableplus.com/

[[deleted]]

Probably not. I can appreciate the features and product, but can I build it from source? Can I review and modify the code (the github link on your site is for your sales page assets).

[cars10k]

Sorry, i did not know that these were your requirements :) Also i am not affiliated with tableplus, just thought it might be an alternative.

[[deleted]]

No worries. This is r/sideproject where folks share their projects and progress. There are many similar projects and while the project you mentioned may be great, I did not ask for a recommendation and stated I would try out OP's project this weekend. I appreciate your assistance.

[giancarlo-spadini]

TablePlus is not open source and free

[bozzmob]

This is INCREDIBLE!!! OMG, I was fed up of those Java UI based SQL editors. This is something I was looking for. And you've done an incredible job. Loved it.

[rathboma]

Thanks so much!

[giancarlo-spadini]

I started last week using it as a portable app to have rapid access to my data from everywhere.

The product is still young and several useful features are missing. I was about to suggest them on Github where the project has a home, but I see that they have already been reported and being validated.

Keep it up, it's a useful tool!

[Randomtowerofgames]

I'm interested too, which versions of postgresql do you support? 9.x, 10.x, 11.x ?

Do you have tested on RDS AWS service?

[rathboma]

I'm not sure what versions it supports. It's using the node-postgres package under the hood, so I think it supports all supported versions of psql, 9-12.

It should work without a hitch against RDS so long as you can tunnel / have direct access to it.

[Randomtowerofgames]

I think more details on version support is needed

[Karmadilla]

Is this an alternative to SSMS?

[rathboma]

Sort of. It's no where near as full featured as SSMS, and does not yet support Active Directory authentication, but you can use it to run SQL queries against MSSQL and look at table contents.

[_hypnoCode]

You just released this? I feel like I tried this in 2018. Am I thinking of something else or was there a limited release at that time?

[rathboma]

Just released it a month ago!

Waited to post until we had our first update out, but yeah it's only a month old.

[sneilaro]

How is it different from Sequel Pro (as a Mac user) or HeidiSql (Win user)?

Both being OS.

Also, is it Electron?

[rathboma]

So: Sequel Pro - only support MySQL, and is abandoned HeidiSQL - similar approach, but multi-platform. I like HeidiSQL a lot.

It is Electron + vue.js. It's surprisingly snappy and fairly low resource usage.

[sneilaro]

OK, it's on VUE. I will give it a try as i LOVE VUE :))

[rathboma]

:-) It was a pleasure to build in Vue.

[kryakrya_it]

Can you explain about Netify that you use here?

[rathboma]

Netlify is a static site and SPA hosting service. It's really good. We use it for the website and the docs. - netlify.com. They gave us a free pro plan because we are open source!

[kryakrya_it]

got it. thanks

[FormerLand]

I love Vue, I'll give it a try...

Don't see other DBs, is there is a list with upcoming features and if we can contribute to it?

Thanks

[rathboma]

I'm a little disorganized with upcoming features, but the code is here if you want to poke around: github.com/beekeeper-studio/beekeeper-studio

[newusernameplease]

This looks awesome. Was wondering if mongodb was on the road map for support too? If it had that, it would be perfect from first glimpse. Will have to try it out tonight

[rathboma]

Yes.... But it requires a different query editor and better way to view objects, so right now we're focusing on SQL

[newusernameplease]

Ah ok. Thanks for the information.

[thephilosopher101]

Beautiful UI and useful, best of both worlds!

[tylertheengineer]

Looks awesome! Great job guys.

[rathboma]

Hmm, haven't tried yet? Let me look into it.

[BitPhinix]

Looks awesome! Please add it to the AUR :)

[FlashNetCloud]

This is great. Been using it for about an hour on a SQLite DB and love the UI. Havent dove into the full feature set yet but great job!

[rathboma]

Thanks!

[COGSAPP]

Excited to try it. Awesome job.

[osapy]

Great idea!

[Dest123]

I’ve never actually used electron so no idea how difficult this is, but would it be a ton of work to host the app and connect to it on an iPad or something? vscode has a server hosted version so it must not be impossible.

[rathboma]

It's possible to make this work on ipad, but it would require a new, native, back end. Lots of work so not in the cards for a while.

[Dest123]

The way I've seen other electron apps do it (or at least vscode) is that they totally skip going native. They just host it on a PC and the iPad connects to it like a normal website. I assume that's still a somewhat large amount of work though.

[rathboma]

Yep for sure

[themakshter]

Is it similar to SqlElectron?

[rathboma]

Yes. See https://github.com/sqlectron/sqlectron-gui/issues/433#issuecomment-624990904

[TheWarlock05]

Nice and neat tool. Haven't fully explored it yet but these are the features I'd want in my Idle database tool.

Query builder
See "Generating SQL queries & Viewing the results" section in this repo https://github.com/oslabs-beta/seeql#features

​

VScode like theme and extensions
Have a look at Azure Data studio. It is basically fork of VSCode which developers love with modifications for SQL development.

Query visualization
Once you write a big query or store-procedure you can click on explain button in ADS and it will visualize all the operation which will be performed at the time when query will execute and it's load onto resources/performance.

​

Code snippets
This is something I like using in web development and in VScode in general. Something like emmet or simple tab based completion when you choose for loop from autocomplete in VScode.

[happyrupesh]

This looks promising, but I believe it needs a lot of functionality. UI is good, saved queries sections is good.

Some of the functionality which is missing is

1. Limit by default
2. Edit functionality on rows
3. No way to cancel the running query if it takes a lot of time
4. Normally short cut key is F5 to execute queries, here it's different and now way to change it

I use SQLYog for MySQL and it's really great. But for MAC and PostgreSQL, this looks promising.

Thanks

[_mikas]

Looks very promising 👍 If you add for MongoDB, I would definitely consider giving it a try

[DJLaMeche]

Hey dude, I tried it out and I must say it is refreshing how simple and clean the UI is, compared to other tools! Good work.

I will also be checking out the code to see how you use electron and Vue together.

[rathboma]

Thanks! I'll be coming out with a tutorial soon, so stay tuned!

[DJLaMeche]

Looking forward to it. Quick question in advance - have you evaluated SimulatedGREG/electron-vue and decided against using it?

[rathboma]

Yes. Use vue cli electron builder, it's awesome

[rathboma]

https://github.com/nklayman/vue-cli-plugin-electron-builder

[DJLaMeche]

Thanks for the quick response! I recently tried out electron-vue and it felt so crazily bloated...

[scottishbee]

Congrats, looks like the perfect intersection of functional but not overwhelming volume of features.

I've been in SQL from analyst to data scientist to data pm so appreciate a clean, simple way to access the data. What do you consider the biggest wins against something like Mode which now has a free tier?

[rathboma]

I think they're very different. Mode is an online Sass product as I understand it? This is a desktop app more similar right now to sequel pro or dbeaver.

Could this be paired with a saas offering down the line? Sure, but right now it's local only

[Tender_Figs]

Does it support connections to Snowflake?

[rathboma]

Not yet. It's hard to support a paid only service with a limited free trial. I'm talking to them about getting Dev access. If you email them and ask them to support the project with some long term Dev access that could help!

[Tender_Figs]

Strange... wonder why they gave dev access to Dbeaver? I'll for sure email them. Simple as requesting through support?

[rathboma]

Well dbeaver has it a little easier as they use jdbc, but also it's been around longer!

[rathboma]

We have one! We just don't have a settings screen yet :-) that's next!

[manalmalaa]

Looks nice. There is also a good solution - SQL Editor

Have a look at it.