common_schema
A framework for MySQL server administration providing SQL-based tools, function libraries, analysis views, and server-side scripting.
What is common_schema?
common_schema is a comprehensive framework for MySQL database administration that provides SQL-based tools to simplify complex administrative tasks. It offers a function library, informational views, a QueryScript interpreter, and a debugger for stored routines, all within a self-contained schema that works with standard MySQL servers. It eliminates dependencies on operating systems and external packages, enabling DBAs to perform tasks directly via SQL.
MySQL database administrators (DBAs) and developers managing MySQL servers who need to automate administrative tasks, analyze database performance and security, and debug stored routines without relying on external scripts or tools.
Developers choose common_schema for its jQuery-like simplicity in MySQL, providing powerful, SQL-native tools that enhance productivity without requiring server modifications, plugins, or complex dependencies. Its lightweight footprint (under 1MB) and compatibility with MySQL 5.1 and above, including Percona Server and MariaDB, make it a versatile and easy-to-install solution.
Overview
DBA's framework for MySQL
Use Cases
Best For
- Automating complex database administration tasks using SQL-based scripts instead of shell scripts.
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
