NCGMP09 is on GitHub. This can be a place to share and collaborate on the development of new tools.
If you have tools you'd be interested in hosting on GitHub, get in touch with Ryan Clark and he'll get you started.
We all need better tools. What ideas are on the burner?
There is all kinds of metadata in the database itself, but some of us are required to produce metadata according to a particular specification. Examples we're familiar with are FGDC (as HTML, XML, or just plain text), ISO19139, Dublin Core, etc. The trick will be determining which are useful, and how much content we can generate from the NCGMP09 tables.
Geologists don't often think it neccessary for them to define "accepted" terms such as
normal fault. However what is clear to one person can often be unclear to another, and so we strive to get the Glossary table fully populated. This could lead to repetitive data-entry for commonly used terms. One idea is to build a tool that runs after you populate the geographic data. The tool would identify all the terms used in the database that NCGMP09 requires be defined in the Glossary table. For commonly-used terms, it might suggest definitions for you.
We could benefit from defining the rules that a database must conform to in order to validate in a single location. Ideally this information would be structured in a way that a computer program could process it. Imagine a structured text document that defines which fields have to exist, which fields can be empty, etc. A desktop application could always look to that service for the most up-to-date, agreed-upon version of what it means to be valid, and then perform the validation on local databases.