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.
MariaDB is a backward compatible, drop-in replacement of the MySQL® Database Server. It includes all major open source storage engines. The source code for MariaDB is publically available from Launchpad. Binaries and packages are also available. MariaDB is community developed in collaboration with Monty Program. Our ambition is to make MariaDB the best open and free version of the MySQL Database Server for end users, developers, and partners.
MongoDB is a document database with the scalability and flexibility that you want with the querying and indexing that you need MongoDB stores data in flexible, JSON-like documents, meaning fields can vary from document to document and data structure can be changed over time The document model maps to the objects in your application code, making data easy to work with Ad hoc queries, indexing, and real time aggregation provide powerful ways to access and analyze your data MongoDB is a...
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
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.
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.
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.
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.
Apache CouchDB is a distributed, fault-tolerant and schema-free document-oriented database accessible via a RESTful HTTP / JSON API. It includes incremental map / reduce mechanics for queries and keeps data safe with an append-only datastore.
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.
Oracle Database delivers industry leading performance, scalability, security and reliability on a choice of clustered or single-servers running Windows, Linux, and UNIX. It provides comprehensive features to easily manage the most demanding transaction processing, business intelligence, and content management applications.
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.
Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981.
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.
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.
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.
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.
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.
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.
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.
