Sequel Pro is a fast and efficient database client for Mac. It's also free and open-source. Unfortunately, not everyone has a Mac. But on the bright side, there are lots of alternatives for Windows and Linux. There are also self-hosted tools that require a web server but provide the same sort of management capabilities.
Most alternatives are free and open-source like Sequel Pro. Some feature packed commercial tools exist as well.
Sequel Pro is notably lightweight and has a visual query builder. There are similar tools, easily filtered using those as features.
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, and much more. MySQL Workbench is available on Windows, Linux and Mac OS.
DBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source (GPL) universal database tool for developers and database administrators. Usability is the main goal of this project, program UI is carefully designed and implemented. It is based on open source framework and allows writing of various extensions (plugins). It supports any database having a JDBC driver. It may handle any external data source which may or may not have a JDBC driver.
HeidiSQL is a useful tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle
DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers. — Intelligent query console Allows you to write queries with coding assistance, errors indicating. Code completion is fast and context-aware. Executes queries in different modes and provides the local history that keeps track of all your activity and protects you from losing your work.
SQL Server delivers on Microsoft’s Data Platform vision by helping your organization manage your data by enabling you to store data from structured, semi-structured, and unstructured documents within the database. SQL Server Express Edition is a free, easy-to-use, lightweight, and embeddable version of SQL Server. It can manage up to 10 GB of data.
Valentina Studio is the universal tool for database architects, developers, DBAs and data workers to work with the most popular RDBMS including Valentina DB, MySQL, PostgreSQL, SQLite, and MS SQL Server. It provides visual data modeling with diagrams, development of database schema, managing records, SQL development and querying, server administration, etc. In PRO you can develop a Valentina Project where design Reports and Forms automating them using JavaScript.
TablePlus is a native app which helps you easily edit database data and structure. TablePlus includes many security features to protect your database, including native libssh and TLS to encrypt your connection. TablePlus supports multi-tab and multi-window viewing, as well as generates code review whenever you make a change to your database. Furthermore, Tableplus also includes Powerful SQL Editor such as Highlight syntax and Indent SQL Command.
Navicat combines functions of other Navicat products and supports most of the features used in modern database management systems, such as Stored Procedures, Events, Triggers, Functions, Views, etc. Navicat enables you to efficiently transfer data across various database systems or to plain text files with SQL format and encoding. Batch jobs for different types of databases can be scheduled to run at a specific time.
SQuirreL SQL is an open-source Java SQL Client program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends and MySQL clients in a single intuitive interface.
Cockroach is a distributed key/value datastore which supports ACID transactional semantics and versioned values as first-class features. The primary design goal is global consistency and survivability, hence the name. Cockroach aims to tolerate disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention. Cockroach nodes are symmetric; a design goal is one binary with minimal configuration and no required auxiliary services.
dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database development, management, and administration. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface. The MySQL client delivers data and schema comparison and synchronization tools, database reporting tools, backup options with scheduling, and much more.
DbVisualizer is the universal database tool for developers, DBAs and analysts. It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases. Compare the editions here: http://www.dbvis.com/features/feature-list/
A simple and lightweight SQL client desktop/terminal with cross database and platform support.
DataRow is the new way of Redshift data management and development with a convenient and intuitive interface. We believe at DataRow, data is the heart of a company and it is more efficient when a team collaborates on its database management. We work hard to help people analyze their databases better.
CUBRID is a comprehensive GPL/BSD open source relational database management system highly optimized for Web Applications. CUBRID is being developed in C/C++. Includes native HA, online hot backup, and other features. JDBC, PHP, ODBC/.NET, Ruby & Python APIs.
Querious is a MySQL database management application written from the ground up for Mac OS X. Unlike mindless Mac OS X ports of applications originally made for Windows or Linux, Querious works the way you'd naturally expect it to as a Mac OS X app. Querious is precise and easy to understand, giving you full control without getting in your way. Viewing, searching, editing, importing, exporting, and structuring your MySQL databases has never been so easy.
Datazenit is a web-based database administration tool. Its abilities go beyond the standard tools of database management, and include data visualizations, an intelligent schema builder and many other features that ease and enhance database management. Datazenit is designed to make databases accessible, safe and easy to use. The final goal is to support many different data sources, but we will start with two of the most popular relational databases: MySQL and PostgreSQL.
SQLPro Studio is the premium database management tool for Postgres, MySQL, Microsoft Management Studio and Oracle databases. Some of the great features include: + Intellisense/SQL autocompletion. + Syntax highlighting with customizable themes (including dark). + Tabbed based interface for an optimal user experience. + Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more! + SQL Beautifier/formatter. + Database wide searching.
Titan is a scalable graph database optimized for storing and querying graphs containing hundreds of billions of vertices and edges distributed across a multi-machine cluster. Titan is a transactional database that can support thousands of concurrent users executing complex graph traversals in real time.
HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92 and SQL:2008 standards. It offers a fast, small (around 1300 kilobytes in version 2.2) database engine which offers both in-memory and disk-based tables. Embedded and server modes are available.
Database browser is an universal table editor. This easy to use tool allows user to connect to any database and browse or modify data, run sql scripts, export, import and print data. And the most important thing it is Free-ware. Connect to any database and browse or modify data, run sql scripts, export and print data. And the most important thing it is Freeware.
This application provides you 'MySQL GUI Admin console' windows. Chrome MySQL Admin provides you the administration GUI of MySQL server. It is like phpMyAdmin, Sequel Pro. Currently, the following features are providing: * Connect to MySQL server (4.1 or later). * Can connect to MySQL server with SSL. * Can connect to MySQL server via SSH2 Port forwarding. * Display the statistics and process list of connected server (refresh automatically).
