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.

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.

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

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.

HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide. Free for everyone, OpenSource. Connect to multiple servers in one window. Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite. Connect to servers via commandline. Connect via SSH tunnel, or pass SSL settings. Create and edit tables, views, stored routines, triggers and scheduled events. Generate nice SQL-exports, compress these afterwards, or put them on the clipboard. Export from one server/database directly to another server/database. Manage user-privileges, import text-files, export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array. Browse and edit table-data using a comfortable grid.

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.

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.

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.