A MySQL database linter

Manually reviewing the quality of a database schema is time consuming and error-prone. This tool, dblint, automates the analysis of database design by statically applying database design rules. New design rules can be easily added. There are two rule types: the metadata level and the data level.

dblint has been implemented and evaluated on MySQL and its derivatives.

Implemented from DBLint (Aalborg Universitet), from which source the numbering scheme has been reused as much as possible. Not all rules are implemented.

Read dblint_overview to see which rules are implemented. Use dblint-script to run all rules on the MySQL command line.

The scripts create the following tables within the same schema as specified in dblint-script:

• dblint_debug: debugging messages; for development purposes only
• dblint_results: results from running dblint, including hints for remediation
• dblint_rules: the dblint rules which have been implemented