dbForge Studio

dbForge Studio for MariaDB is a universal IDE with GUI tools that has all the necessary built-in capabilities to work with MariaDB and MySQL databases for their development, management, and administration. It allows for creating, managing, and editing the data without the need to store them locally.

This GUI tool offers a rich visual design that is perfect for working with large scripts, preparing data reports, and database projects. At any time, you can back up or restore your data, export or import them to and from the most commonly used formats, and compare or synchronize the MariaDB databases.

Features are described in the following.

Intelligent SQL Coding

• Automatic code completion.

• MariaDB syntax highlighting.

• Code refactoring and formatting.

• CRUD generation.

Database Compare and Sync

• Data and schema synchronization and comparison.

• Recurring database sync tasks planning.

• Comparison report generation.

Import and Export Data

• MariaDB data export to commonly used formats.

• Data import from popular formats into MariaDB table.

• Rich customization ability.

• Command-line automation for data tasks.

MariaDB Administration Tools

• MariaDB databases backing up and restoring.

• User accounts and permissions configuration.

• Table maintenance.

• Database scripts generation.

Copy Database

• Source and Target server selection.

• Database to be copied or dropped selection.

• Configuration of the database copying parameters.

• Progress of copying tracing and abortion of the copying.

Database Designer

• Schema diagrams generation.

• Visual database construction.

• Foreign key relations between tables.

Data Generator

• Data customization supported by multiple generators.

• All kinds of generators: basic, meaningful, and user-defined.

• Real-time preview of generated data.

• Command-line interface.

Query Profiler

• Visual query profiling.

• Profiling results comparison.

Visual Query Builder

• Automatic generation of the script template for queries.

• Easy navigation through the database objects.

• Support for different query types.

• Support for sequence tables.

Table Designer

• Table creation and editing in MariaDB with no code.

• Automatic data type setting for frequently-used column values.

• Errors prevention while working with tables.

• MariaDB script automatic generation according to the changes made by a user.

Database Refactoring

• Renaming database objects with preview.

• Refactoring script.

Source Control

• Version control of database schemas and static table data.

• Compatibility with all major version control systems.

• Dedicated and shared development models.

• Quick comparison of database versions.

• Examination and resolution of conflicts.

• History of changes.

Database Projects

• MariaDB version control system providing efficient database team development.

• Scripts folder for exporting a database project to a MariaDB script file.

Report and Analysis

• Pivot tables for summarizing and viewing the data.

• A powerful wizard with robust features.

• Full command line support.

• 9 formats for reports' delivery.

Database Documenter

• A comprehensive overview of the database structure.

• Examine the internal dependencies between objects and databases.

• Customize the style and generate the docs in several formats.

Support for MariaDB Objects

• Packages.

• Sequences.

• Temporal tables.

This database tool is one of the most appreciated worldwide and trusted by many people. Devart’s dbForge Studio has received a lot of awards that confirm its overwhelming popularity.

Download a free 30-day trial of dbForge Studio for MariaDB and MySQL here.

Documentation is available, too.

_{This page is licensed: CC BY-SA / Gnu FDL}