Beekeeper Studio is a modern, easy-to-use, and good looking SQL client for MySQL, Postgres, SQLite, SQL Server, and more. The current version has new superpowers, such as drop/truncate support, Redshift IAM auth, markdown data exports, and gained some formatting memory.
The app lets you encrypt your connection with SSL, or tunnel through SSH. You just save a connection password and Beekeeper Studio will encrypt it. The built-in editor provides syntax highlighting and auto-complete suggestions for your tables so you can work quickly and easily. You can open dozens of tabs so you can work quickly without having to switch windows. Table DDL and data views get their own tabs too. You can easily save and organize commonly used queries so you can use them again and again across all your connections. The tool supports fast and simple table editing with the ability to stage changes. Beekeeper's SQL table creator lets you create, edit, and delete table columns in just a few clicks. You can export a table to CSV, JSON, JSONL, or SQL with just a few clicks. Optionally, you can apply filters to export only the data you need.
This is a tool to create, design and edit database files compatible with SQLite.
