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.

Features

  • SchemaCrawler grep to find tables and columns using regular expressions
  • Schema lint to find problems with schema design
  • Scipting against your database, using JavaScript
  • Database diagramming

Project Samples

Project Activity

See All Activity >

Follow SchemaCrawler

SchemaCrawler Web Site

Other Useful Business Software

Reduce Support Costs with TeamSupport’s B2B helpdesk Reduce Support Costs with TeamSupport’s B2B helpdesk Icon
Reduce Support Costs with TeamSupport’s B2B helpdesk Icon

Improve customer satisfaction with powerful and easy to use helpdesk software built specifically for business to business customer support.

We do what you do – business software – so we get it. Customer support is critical to any business and as a B2B provider you not only need to manage contacts and tickets, you need to understand your business relationships at a customer level. TeamSupport is the only helpdesk software built for B2B and made to scale with you as you grow.
  • Easy to Use and Fully Customizable to Your Business
  • Relational Customer Database and Best in Class SLAs

Rate This Project

Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
10
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5

User Reviews

  • 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!

    2 users found this review helpful.
Read more reviews >

Additional Project Details

Intended Audience

System Administrators, Developers, Quality Engineers, Testers

Programming Language

Java

Database Environment

JDBC

Registered

2005-09-14