SchemaCrawler Icon

SchemaCrawler

Database schema discovery, comprehension and documentation tool.

5.0 Stars (8)
335 Downloads (This Week)
Last Update:
Download SchemaCrawler 10.10.05 - Main Download
Browse All Files
BSD Windows Mac Linux

Screenshots

Description

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 Web Site

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

Update Notifications





User Ratings

★★★★★
★★★★
★★★
★★
8
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
Write a Review

User Reviews

  • adriens
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    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 !

    Posted 07/31/2014
  • oop123
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    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!

    Posted 08/30/2013
  • mariaramey2
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Thanks for Schemacrawler, it's great!

    Posted 06/09/2013
  • diegrossoitty
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    I liked it, I recommend

    Posted 02/05/2013
  • codeprese
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Very useful project!

    Posted 06/01/2012
Read more reviews

Additional Project Details

Intended Audience

System Administrators, Developers, Quality Engineers, Testers

Programming Language

Java

Registered

2005-09-14
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.