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 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.

Flexibility and diversity of the features make it possible to create an app that perfectly suits your taste. Dozens of types of fields, including text, number, date/time, checkboxes, currency, image, file, calculation, locations, relations and others. Displaying data in the form of a list, a set of cards, a table, on a map, or in a calendar. Performing Data analysis, including aggregation, charting, sorting, grouping, and filtering entries by any fields. Memento allows the synchronizing of data with the cloud and provides various tools for teamwork. Huge functionality for experienced users and simplicity for the ones who just want to organize the everyday life are connected in a single solution that do work for numerous cases. Memento supports offline work. You can transfer data in the offline mode and synchronize it with the cloud later.Memento's catalog of user templates contains thousands of predefined, ready-to-use libraries to use directly or serve as a starting place.

SQLGate is a simple but powerful IDE for multiple SQL databases. As an integrated database management and development solution, it simplifies the construction and operation of databases. It is customized for seven different databases that make up 83.2% of the DBMS market. These include Oracle, SQL Server, MySQL, MariaDB, Tibero, and PostgreSQL. SQLGate makes it easier and quicker to deal with databases holding large amounts of data. Multiple Languages available: Korean, English, Spanish, French, Japanese, etc..

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.

AnySQL Maestro is the premier multi-purpose admin tool for database management, control and development. SQL Maestro Group offers complete database management and web development solutions for all the most popular database servers providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Support of any database engine (SQL Server, MySQL, Access, etc.) Database designer, data management, editing, grouping, sorting and filtering abilities. Handy SQL Editor with code folding and multi-threading. Visual query builder, data export/import to/from the most popular formats. Powerful BLOB viewer/editor. The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more. High-quality DB2 tools which are as easy in use as Windows explorer.

WinSQL is a powerful universal database management tool that is used by 90 percent of Fortune 500 companies and more than a million programmers and DBAs around the globe. WinSQL is a generic querying tool that connects to any relational database (RDBMS) for which an Open Database Connectivity (ODBC) driver is available, virtually all RDBMS on the market today. Connect to a variety of databases, including: heavy duty vendors Oracle, MS SQL Server, DB2, Sybase, Informix to lightweight backends like MS Access, DBase, and Text File. Generate royalty-free executables that can be used by your business users to run queries. These can be either static or dynamic queries that pull fresh data from the back-end. Export or simply open any query results into MS Excel with just a click of your mouse. You can even import an existing Excel spreadsheet to a database table by simply dragging an *.XSL file in the catalog tree.

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.

There are different ways to cut IT department costs, but the most intelligent and profound way is by increasing employee productivity. Once you implement efficient work methods you pave the way for continuous saving and improvement. Kal Admin is an indispensable software for hundreds of Analysts, Developers, QAs and DBAs in the public service in Israel. Kal Admin's Data Dictionary is a repository where Business Analysts store definitions and descriptions of data elements required to satisfy end user requirement. Business terminology can be stored in the Dictionary as well. The Dictionary is used later for building tables in the database. Using Kal Admin, tables can be defined without actually building them in the database. Columns in the table are defined using the Data Dictionary. Once the defined tables pass quality assurance you can build them in the database with a click.

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.

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.

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.

Suneido™ is a complete, integrated application platform – a system for developing and deploying applications without the frustrations of integrating multiple different products. Suneido incorporates an object-oriented programming language, client-server relational database software, and application frameworks and components. It includes the integrated development environment (IDE) used to create applications as well as the client and server required to run applications across networks. Suneido is Open Source – it is provided free, with complete source code. Our mission is to provide a simple, open, lightweight, industrial strength alternative to large, complex, expensive, closed application technologies such as Visual Basic, Access, FoxPro, Delphi, Oracle, and SQL Server.