Automating MySQL SQL Audits with Inception and Overmind

SQL audit and execution are critical DBA tasks that have traditionally been performed manually, leading to low efficiency and inconsistent quality. To standardize operations and improve speed, the team adopted the popular open‑source SQL audit tool Inception and built a web UI named Overmind.

Inception

GitHub: https://github.com/mysql-inception/inception

Documentation: http://mysql-inception.github.io/inception-document

Inception is an open‑source MySQL automation tool offering SQL audit, execution, and rollback. Developed from MySQL source code, it can accurately review statements and works like a regular MySQL client. Although development stopped two years ago, it remains compatible with most MySQL versions and is a leading open‑source SQL audit solution.

Architecture of Inception :

Overmind

Audit Process

The audit workflow is divided into two parts:

Dev and QA environments: developers can submit audits or executions directly through Overmind.

Production environment: after successful Dev/QA runs, a “request deployment” button sends an email to the DBA; the DBA must approve before the changes go live.

System Introduction

Basic configuration page: configure Inception connection directly in the UI.

Database information entry: a simple CMDB‑like interface for managing database details.

Audit task submission: supports audit‑only and audit‑then‑execute modes.

Audit result display: shows submitter, operation, audit outcome, and other details.

Task list page: filter tasks by submitter, project, or environment.

Open Source

The author previously open‑sourced a simple Python backend but stopped maintenance; another similar open‑source product, Yearning, is available on GitHub.

Conclusion

Thanks to the Inception creator – a true blessing for DBAs.

Overmind was built in three days using existing frameworks, making development fast.

Deploying the tool is straightforward, but integrating it into existing processes requires comprehensive documentation and minimal user friction.

Hope the community continues to update Inception for the benefit of DBAs.