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.
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.
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.
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.
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.
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.
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).
SQL Maestro for MySQL is the premier MySQL admin tool for MySQL database management, control and development. Key features include: - Support for all the MySQL server versions from 3.
PopSQL is a modern SQL editor for teams that lets you write queries, visualize data, and share your results. Features: - Share queries by URL, and organize them in folders Stop emailing SQL queries or pasting them in chat. Simply share the URL to your query or results so your team can see your analysis. Create folders to organize your queries by project or department. Folders can be private to you, or shared with your team.
Skipper, previously ORM Designer, is a visualization tool and a code generator for favourite ORM frameworks (Doctrine ORM, Doctrine2 ORM, Propel ORM and CakePHP). Application allows to edit ORM models in graphical interface and then export them directly to standardized and ready-to-use schema definition files. With Skipper, you can focus only on project logic, as syntax and keywords are taken care of by Skipper.
Valentina DB ADK allows you to develop applications that 1) embeds super-fast local Valentina db engine 2) is a client to Valentina Server 3) combines both. Valentina DB ADK can be used on 3 OS and with any major language/IDE: C/C++/ObjC/C#/.NET, Java, REALbasic/Xojo, LiveCode, PHP, Ruby, ... You can use SQL style of coding, as well as non-SQL using Valentina API with near to 40 classes and 1000 methods total. You can use ADK for FREE when using it as CLIENT to VServer.
UnQLite is a in-process software library which implements a self-contained, serverless, zero-configuration, transactional NoSQL database engine. UnQLite is a document store database similar to MongoDB, Redis, CouchDB etc. as well a standard Key/Value store similar to BerkeleyDB, LevelDB, etc. UnQLite is an embedded NoSQL (Key/Value store and Document-store) database engine. Unlike most other NoSQL databases, UnQLite does not have a separate server process.
