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.
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...
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.
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.
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.
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.
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).
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.
Emma is a graphical toolkit for MySQL database developers and administrators. It provides dialogs to create or modify MySQL databases, tables, and associated indexes. The results of an executed query are displayed in a result set where the record data can be edited by the user, if the SQL statement allows for it. The SQL editor and result set view are grouped in tabs. Results can be exported to CSV files. Multiple simultaneous opened MySQL connections are possible.
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.
