SchemaCrawler is an open-source Java API that makes working with database metadata as easy as working with plain old Java objects.
SchemaCrawler is also a database schema discovery and comprehension, and schema documentation tool. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas.
SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java.
- SchemaCrawler grep to find tables and columns using regular expressions
- Schema lint to find problems with schema design
- Database diagramming
This has been very useful for making sure that our database schemas stay in sync.
Amazing tool! Fits ERD neatly in a page!
Excellent tool, makes me very productive and help me communicate with other people on the database schema quality. I also greatly appreciate lint, and the possibility to add custom lints. Great tool, thanks a lot !
Worked fine for me, was able to catch a bug in my jdbc driver which I couldnt narrow down because I didnt want to wade through the entire .getMetaData jdbc api. I hope I really got them all!
Thanks for Schemacrawler, it's great!