More ideas

[fatkodima]

1. Detect invalid indexes/constraints
2. Detect duplicate indexes - with identical structure or prefixes of each other
3. Detect columns near integer overflow
4. Detect empty tables (or not accessed within some threshold period). Would be useful when cleaning up/refactoring a messy db schema.
5. Detect useless columns - columns having only one distinct value or only nulls. Caution: this check will be costly on large tables.
6. Method to return current connections info
7. Method to return current db settings