I'm trying to improve the knowledge management of MySQL structures available on a project. By structure, I mean tables, views, functions, procedures, triggers.
All these structures are extracted in .sql files.
I'm looking for a way to document these structures, presenting results à la doxygen in HTML files. For example, I want this tool to group functions in a section, with documentation tags extracted and reformatted to be human-readable added to each function.
I tried looking at doxygen, but it seems it does not support sql yet.
I need tools that can be run in batchs, using a linux environment.
What tools do you know ? Do you have advices on how to achieve good knowledge management of databases ?
I found pldoc. I will try it to see if it fits my needs.