dbForge Studio for MariaDB

dbForge Studio is a multifunctional IDE that has all the necessary built-in capabilities to work with MariaDB databases. It allows for creating, managing, and editing the data without the need to store them locally.

This powerful 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. Apart from that, dbForge Studio supports SkySQL (the MariaDB cloud database), as well as other MySQL Server versions, Percona servers, MySQL and MariaDB on Amazon RDS and Amazon Aurora. dbForge Studio might be of great help while working with Galera Cluster, Google Cloud, Alibaba Cloud, TokuDB, Tencent Cloud, Sphinx, etc.

Key Features:

1. Intelligent SQL Coding

• Automatic code completion
• MariaDB syntax highlighting
• Code refactoring and formatting
• CRUD generation

2. Database Compare and Sync

• Data and schema synchronization and comparison
• Recurring database sync tasks planning
• Comparison report generation

3. Import/Export Data

• MariaDB data export to 14 commonly-used formats
• Data import from 10 popular formats into MariaDB table
• Rich customization ability
• Command-line automation for data tasks

4. Database Administration

• MariaDB databases backing up and restoring
• User accounts and permissions configuration
• Table maintenance
• Database scripts generation

5. Copy Database

• Source and Target servers’ selection
• Database to be copied or dropped selection
• Configuration of the database copying parameters
• Progress of copying tracing and abortion of the copying

6. Database Designer

• Schema diagrams generation
• Visual database construction
• Foreign key relations between tables

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

8. Query Profiler

• Visual query profiling
• Profiling results comparison

9. Visual Query Builder

• Automatic generation of the script template for queries
• Easy navigation through the database objects
• Support for different query types

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

11. Database Refactoring

• Renaming database objects with preview
• Refactoring script

12. Database Projects

• MariaDB version control system providing efficient database team development
• Scripts folder for exporting a database project to a MariaDB script file

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

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

15. Support for Maria DB objects:

• Packages
• Sequences

Nowadays, with the growing popularity of the MariaDB database, the demand for a convenient, multi-functional tool is increasing, too. This solution must meet users’ needs, be easy to work with and provide constant support. Fortunately, dbForge Studio for MySQL is such a solution. This database tool is one of the most appreciated worldwide and trusted by many people. Devart’s dbForge Studio for MySQL has received a lot of awards that confirm its overwhelming popularity. If you want to try its amazing features, download dbForge Studio for MySQL here.

Documentation

Editions