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
- Easy to Use and Fully Customizable to Your Business
- Relational Customer Database and Best in Class SLAs
Rate This ProjectLogin To Rate This Project
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!