MySQL Workbench
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X. MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections.
Learn more
DBeaver Community
DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more.
Connect to popular SQL databases (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, etc.)
SQL editor to create queries with syntax highlighting and autocompletion
AI assistant in SQL for building queries through natural language
SSL/TLS support for encrypted connections
SSH tunneling for secure remote access
Proxy configuration to work with databases behind a corporate firewall
Session Manager to terminate, disconnect, view and search for sessions
Lock Manager to monitor and manage database locks
Entity Relationship Diagrams to interactively explore and visualize database structure
Query manager to view all executed queries, including execution time, duration, affected rows, and errors.
Data editor to view, edit, and filter data
Learn more
PopSQL
PopSQL is a collaborative SQL editor and workspace that connects everyone in the data analysis process so that teams can obtain better data insights and visualizations by asking the right questions, together.
* Get answers faster with real-time collaboration, version history, searchable shared queries and folders. We make it easy for your power SQL users and data analysts to work with business stakeholders
* Built-in data visualization & sharing lets you go from query to chart to Slack in seconds. Build, schedule and push real-time insights and dashboards, in just a few clicks.
* Our modern and elegant cloud-based workspace offers a rich SQL editing experience. Dive right in, connect to your databases and iterate on analyses from anywhere. We offer native macOS, Windows, and Linux clients.
* One workspace to get it done: PopSQL puts your database connections, shared credentials and an intuitive data catalog at your fingertips so you can access & mine your data, safely, securely
Learn more
JackDB
Write and execute queries in a fully interactive SQL editor. JackDB has everything you'd want in a database client, including: syntax highlighting, code formatting, and intelligent autocompletion. Snippets allow your most useful SQL queries to be saved and shared. Simply write and save any query in JackDB, and share the snippet publicly with your team. Whenever anyone updates a snippet, everyone gets access to its latest version. Security is our highest priority at JackDB. Roles are a very convenient and secure way to restrict database access to authorized users and provision new users with access to data sources. Explore everything in your database, not just tables and views. View your indexes, schemas, and other important system details such as tablespaces and user sessions.
Learn more