Frabit is an open-source database automatic platform for teams. It offers a web-based workspace for DBAs and Developers to collaborate and manage the database change safely and efficiently.

As GitLab/GitHub provides a GUI and collaboration workspace for teams to manage code, Frabit does the similar job for managing database. This is the most significant difference from all existing schema migration, SQL client tools.

Key Features

SQL Review

Frabit analyzes SQL changes to enforce rules in compliance with your organization's policy. The enforcement includes naming conventions, anti-SQL pattern detection and etc. Prod and non-prod environments can also enforce different rules respectively.

Database CI/CD and Change Automation

Like code review, Frabit streamlines the database change process. Within a single workflow, a database change can be reviewed and deployed from the dev environment all the way to the production environment.

Query Web Editor

A web-based Query Editor to query and export data. DBAs no longer need to give away sensitive database credentials when Developers need to access the data.

Data Access Control and Governance

Frabit provides a suite of features to enable organizations to enforce data security policies, avoid data leaks and conform compliance.

Data Rollback and Disaster Recovery

• Statement-level rollback

• Instance-level manual and periodical backup and restore

• Point-in-time recovery (PITR)