A framework for MySQL server administration providing SQL-based tools, function libraries, analysis views, and server-side scripting.
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.
DBA's framework for MySQL
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Includes text manipulation, security routines, and execution control functions, reducing reliance on external shell scripts for common tasks.
Provides SQL-based views for security analysis, schema design insights, and process monitoring, enabling direct database diagnostics without extra tools.
Offers a QueryScript interpreter for advanced automation, likened to jQuery for JavaScript, allowing complex logic execution within MySQL.
Installation size under 1MB and no need for server modifications or plugins, making it easy to deploy on standard MySQL servers.
The rdebug debugger for stored routines is marked as alpha, implying instability and limited functionality for production use.
On some MySQL versions, setting stack_size in the configuration file is necessary, adding an extra step during setup.
Limited to MySQL, Percona Server, and MariaDB, making it unsuitable for environments with heterogeneous database systems.