Best Free Database Management Systems (DBMS)

DbVisualizer is one of the world's most popular database editors. With almost 7 million downloads and Pro users in 150 countries worldwide, it won't disappoint you. Free and Pro versions are available. Developers, analysts, and DBAs use it to elevate their SQL experience with modern tools to visualize and manage their databases, schemas, objects, and table data, auto-generate, write, and optimize queries, and so much more. It connects to all popular databases, such as MySQL, PostgreSQL, SQL Server, Oracle, Cassandra, Snowflake, SQLite, BigQuery, and 30+ others, and runs on all popular OSes (Windows, macOS, and Linux). A powerful SQL editor with intelligent autocomplete, visual query builders, variables, and more. You can fully control window layouts, key bindings, UI theme, mark scripts, and database objects as favorites for quick access or even work outside of DbVisualizer. DbVisualizer is also built to meet rigorous security standards, all configurable within the product.

Percona XtraDB Cluster (PXC) is a high availability, open-source, MySQL clustering solution that helps enterprises minimize unexpected downtime and data loss, reduce costs, and improve the performance and scalability of your database environments. PXC supports your critical business applications in the most demanding public, private, and hybrid cloud environments. Percona XtraDB Cluster (PXC) preserves, secures, and protects data and revenue streams by providing the highest level of availability for your business-critical applications. PXC helps you increase efficiency, eliminate license fees, and lower your total cost of investment, helping you meet budget constraints. Our integrated tools enable you to optimize, maintain, and monitor your cluster. This ensures you get the most out of your MySQL environment.

Percona Distribution for PostgreSQL is a single source which provides an enterprise-grade, open source installation of PostgreSQL Core Distribution, plus critical additional enterprise components. PostgreSQL Core Distribution is an ACID-compliant relational database management system, supporting a wide range of data types and user-defined objects. A stable and secure open source product, PostgreSQL Core Distribution is relied upon by multiple organizations. You no longer need to find solutions for common requirements, like high availability and backup, on your own. When you install Percona Distribution for PostgreSQL, you get everything you need to be up and running with PostgreSQL, including PostgreSQL Core Distribution, pg_repack, pgaudit, pgBackRest, and Patroni. Percona Distribution for PostgreSQL delivers all of this in a single installation. The components are tested to work together and, along with the PostgreSQL Core Distribution, they are updated as required.

Auto-complete queries in a built-in mongo shell that highlights syntax errors as you type and saves your query history. Perfect for MongoDB beginners, a time-saver for pros. Use a drag-and-drop UI to build complex find() queries and filter array elements. Break down aggregation queries into manageable steps and build them stage by stage, for easier debugging and querying. Generate instant code in JavaScript (Node.js), Java (2.x and 3.x driver API), Python, C#, PHP, and Ruby from MongoDB and SQL queries that you can copy and paste into your application. Save MongoDB imports, exports, data comparisons, and migrations as tasks that you can run on demand. Or even better, skip the reminders and schedule them to run exactly when you need them. Make changes to your collection’s schema in just a few clicks, perfect for schema performance tuning, restructuring, or cleaning up after data migration.

Organize your work your way with Airtable. An all-in-one collaboration software, Airtable combines the power of a relational database with the flexibility and ease of use of a spreadsheet. It works across platforms and devices, and syncs data in real-time. Users can choose from different formats to view the tasks at hand, including grid, calendar, Kanban, gallery, and forms.

MongoDB is a general purpose, document-based, distributed database built for modern application developers and for the cloud era. No database is more productive to use. Ship and iterate 3–5x faster with our flexible document data model and a unified query interface for any use case. Whether it’s your first customer or 20 million users around the world, meet your performance SLAs in any environment. Easily ensure high availability, protect data integrity, and meet the security and compliance standards for your mission-critical workloads. An integrated suite of cloud database services that allow you to address a wide variety of use cases, from transactional to analytical, from search to data visualizations. Launch secure mobile apps with native, edge-to-cloud sync and automatic conflict resolution. Run MongoDB anywhere, from your laptop to your data center.

The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data. Cassandra's support for replicating across multiple datacenters is best-in-class, providing lower latency for your users and the peace of mind of knowing that you can survive regional outages.

Ragic is a no-code database builder that allows its user to build their own system according to their own workflow with a spread-sheet like interface that is as quick and as intuitive, capable of building small contact management systems to fully fledged ERP systems.

dbForge Edge is the newest Devart product - the multidatabase software solution covers all database-related jobs, allowing its users to accelerate the tasks' completion, save costs, and improve overall productivity. A set of powerful features applies to all most popular database management systems - MySQL and MariaDB, SQL Server, Oracle, and PostgreSQL. Notice the most helpful features of dbForge Edge: Database design & development. Convert ER diagrams to actual databases or reverse-engineer databases. SQL coding assistance. Visual query building. Query profiling. Database comparison & synchronization. Deploy changes to the target databases on different platforms. Data management. Data import/export. Data analysis and reporting. Database administration.

One area hasn’t benefited from the DevOps movement as much: The database change process. It’s time to bring CI/CD to the database. Application release technology has come a long way in the past several years. It used to take weeks or even months to release new software. Now that organizations have adopted new workflows and processes, the time it takes to complete a release has been reduced to days and even hours. Database schema migrations are an essential task for every software project. There are several different reasons why updates to the database are required. New features require new attributes in existing tables or entirely new tables. Bug fixes may lead to changes in names or data types in the database. Performance issues that require additional indexes in the database. Even in organizations that have adopted DevOps, manual rework is the norm when it comes to database schema and stored procedure changes.

dbForge Studio for MySQL is a multi-featured IDE that covers nearly every aspect of MySQL and MariaDB development, management, administration, data analysis, and reporting. The rich feature set of the Studio is augmented by a clean and intuitive GUI and CLI-powered automation capabilities. Key features: Database Development. dbForge Studio for MySQL offers quite a few features to streamline routine SQL coding and ensure the high quality of the output. Database Design. In terms of database design, the Studio provides visual object editors and handy functionality that helps you visualize databases on entity-relationship diagrams. Database Management. The Studio delivers a set of features for effective and versatile database management. Data Analysis & Reporting. dbForge Studio for MySQL facilitates data aggregation, analysis, and reporting. Database Administration. There are also integrated features to ensure quick and smooth database administration.

dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to customize your queries and property window so that users can view all the required information of PostgreSQL database objects they are interested in. Key features: *SQL Development. Save your time and improve code quality when creating and editing queries. *Explorer. Navigate through the object tree and find any PostgreSQL object you want. *Data Editor. Users can manage the settings of tables. *Data Export and Data Import. Supports 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios. *Query Profiler. *Data and Schema Compare. *Data Generator. *Pivot Table.

dbForge Studio for Oracle is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data. This Oracle IDE allows synchronizing data between different Oracle servers and automating schema change management process during development. dbForge Oracle GUI features powerful functionality wrapped into a smooth management Oracle GUI consistent with Microsoft Visual Studio. Key features: * PL/SQL coding assistant * Database Project * Oracle Database Management * Data Generator * Documenter * Object Manager * Oracle PL/SQL Debugger * Query Builder * Query Profiler * Schema Import/Export * Database Administration * Database Designer * Import/Export Data * Report and Analysis * Find Object You can always find the latest version of the product on the official Devart website.

Entrust YDB with keeping your application state regardless of how large or frequently modified it is. Handling petabytes of data and millions of transactions per second is not an issue. Build analytical reports based on data you store in YDB with performance comparable to database management systems purpose-built for this use case. No compromises on consistency and availability are necessary. Use the YDB topics feature to reliably send data between your applications or consume change data capture feed from regular tables. Exactly-once and at-least-once semantics are available to choose from. YDB is designed to work in three availability zones, ensuring availability even if the whole availability zone goes offline. It recovers automatically after a disk, server, or data center failure with minimum latency disruptions for applications.

Firebird is a relational database offering many ANSI SQL standard 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. The Firebird Project is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000. The Firebird Project supplies users, developers, and administrators with various kinds of documentation, from Quick Start guides to expert-level articles devoted to various aspects of Firebird.

Quest Database Management Solutions. Today’s database technology is becoming increasingly complex, and supports previously unthinkable data volumes – all driven by the demands of today’s always-on economy. This drives most organizations to spend up to 65% of their time just keeping the lights on, leaving very little time to deliver innovations that move the business forward. Digital transformation initiatives such as cloud migration, DevOps, open-source database adoption and data privacy require commitment and time from IT at a time when they are already under huge pressure to maintain service levels. It’s time for a new approach. Spend less time managing your data environment, and more time building a data-driven business. As the top-ranked ISV for database management software tools in the world, we help you simplify this complex technology in order to manage, monitor and move your data across a wide variety of on-premises and cloud-based systems.

Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. Security is #1 priority in development of Adminer. Adminer does not allow connecting to databases without a password and it rate-limits the connection attempts to protect against brute-force attacks. Still, consider making Adminer inaccessible to public by whitelisting IP addresses allowed to connect to it, password-protecting the access in your web server, enabling security plugins (e.g. to require an OTP) or by customizing the login method. You can also delete Adminer if not needed anymore, it is just one file which is easy to upload in the future. Adminer had some security bugs in the past so update whenever Adminer tells you there is a new version available (ask your administrator if you could not update yourself). Connect to a database server with username and password. /Select an existing database or create a new one.

InterSystems Caché® is a high-performance database that powers transaction processing applications around the world. It is used for everything from mapping a billion stars in the Milky Way, to processing a billion equity trades in a day, to managing smart energy grids. Caché is a multi-model (object, relational, key-value) DBMS and application server developed by InterSystems. InterSystems Caché provides several APIs to operate with same data simultaneously: key-value, relational, object, document, multi-dimensional. Data can be managed via SQL, Java, node.js, .NET, C++, Python. Caché also provides an application server which hosts web apps (CSP), REST, SOAP, web sockets and other types of TCP access for Caché data.

PostgreSQL GUI tool for macOS. PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly. pgAdmin is great for its feature-richness. However, its UI is clumsy and complicated. There is a list of PostgreSQL GUI Tools. However, they are either web-based, Java-based or don't support the features some want. In the good old MySQL world, the best client is Sequel Pro, but its support for PostgreSQL doesn't seem to be happening. So, we decided to make one. PSequel is written from scratch in Swift 2, although PSequel's UI is highly inspired by Sequel Pro. PSequel is being developed in our spare time. By supporting macOS 10.10+ only, the codebase can be kept simpler and save time by not testing it in older versions of macOS. And, less code, less bugs. PSequel is still in its early stage.

SAP HANA in-memory database is for transactional and analytical workloads with any data type — on a single data copy. It breaks down the transactional and analytical silos in organizations, for quick decision-making, on premise and in the cloud. Innovate without boundaries on a database management system, where you can develop intelligent and live solutions for quick decision-making on a single data copy. And with advanced analytics, you can support next-generation transactional processing. Build data solutions with cloud-native scalability, speed, and performance. With the SAP HANA Cloud database, you can gain trusted, business-ready information from a single solution, while enabling security, privacy, and anonymization with proven enterprise reliability. An intelligent enterprise runs on insight from data – and more than ever, this insight must be delivered in real time.