Stack Overflow
Stack Overflow

Questions tagged [schemacrawler]

SchemaCrawler is a free database schema discovery and comprehension tool.

SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint.

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 8 or better.

108 questions
5
votes
3 answers

Trying to connect to sqlite db using schemacrawler using OSX - why is it asking for a user?

See bottom for conclusion: I'm trying to use schemacrawler to diagram a sqlite database. My setup: OSX 10.8 SchemaCrawler 10.5 downloaded from Here Java version 1.7.0_45 downloaded from Oracle sqlite version: 3.7.12 2012-04-03 19:43:07…
Steve Broberg
  • 4,255
  • 3
  • 28
  • 40
3
votes
0 answers

Schemacrawler table/column comments/remarks SQL Server

I'm using a SQL Server database, my INFORMATION_SCHEMA doesn't contain TABLE or COLUMN comments, I want to add these to a generated output. So far I've been able to generate a html using a custom query that queries sys.extended_properties, but this…
aeroraver
  • 31
  • 1
3
votes
1 answer

Alternatives to SchemaSpy

I am looking for a open source tool that can be used to generate ER diagram. Currently, this is done using SchemaSpy. Maven scripts are invoked during jenkins build to generate these data model diagrams. I have tried POCs using SchemaCrawler as…
venkatesh
  • 435
  • 1
  • 5
  • 9
3
votes
1 answer

How to make SchemaCrawler work in Windows?

How to make SchemaCrawler to work in Windows? GraphViz is installed. Now I'm trying to make a diagram of a whole PostgreSQL database using the command line: sc.cmd -command graph -outputformat png \ -outputfile=graph.png -database=my_database \ …
Paul
  • 25,812
  • 38
  • 124
  • 247
2
votes
1 answer

Label foreign key lines on schema for sqlite db?

I'm generating a schema diagram against a sqlite3 database using schemacrawler. The foreign key relationship lines all have some sort of arbitrary alphanumeric string label on them, like SC_8D200EE2_9FA6C015. I would like to explicitly label some…
rjt_jr
  • 303
  • 1
  • 6
2
votes
0 answers

SchemaCrawler show table comment on html output

I'm calling SchemaCrawler in the following way: call java -classpath ../_schemacrawler/lib/*;lib/* schemacrawler.Main -server=mysql -database=db_db -host=localhost -user=user -password=pwd -infolevel=maximum -command=brief -portablenames=false…
KcFnMi
  • 5,516
  • 10
  • 62
  • 136
1
vote
2 answers

Required Java API to generate Database ER diagram

Is there any java API/java plugin which can generate Database ER diagram when java connection object is provided as input. Ex: InputSream generateDatabaseERDiagram(java connection object)// where inputsream will point to generated ER diagram…
Rajesh
  • 2,934
  • 8
  • 42
  • 71
1
vote
1 answer

Using Java schemacrawler, why is it scanning every table in my database?

Using Java schemacrawler, why is it scanning every table in my database? Shouldn't it just be scanning the database I specified on the command line: -database=openfire ??? :: schemacrawler batch launcher @echo off C:\JDK\bin\java.exe -classpath…
djangofan
  • 28,471
  • 61
  • 196
  • 289
1
vote
2 answers

SchemaSpy Testcontainers. Copy results from the container

I want to run SchemaSpy container against PosgtreSQL database to generate the documentation. Here is the approach I came up with: Start PostgreSQL. Start SchemaSpy with overridden entrypoint (/bin/sh). Run execInContainer to run the SchemaSpy app…
Semyon Kirekov
  • 1,237
  • 8
  • 20
1
vote
0 answers

AWS Crawler stuck in STOPPING state

I have a crawler that was working fine defining the schema of a parquet file in S3, but I came across a CrawlerRunningException when I ran it again. I checked its status and it has been stuck in STOPPING for some reason I don´t get. I can´t even…
Nico Arbar
  • 166
  • 1
  • 8
1
vote
3 answers

Truncated table names in diagrams on Ubuntu

My SchemaCrawler (version 15.01.03) schema diagrams are truncating table names on Ubuntu 18.04 LTS. It looks like the tables are drawn too narrow in general because the "[TABLE]" notation also bleeds out of the box. The same looks fine when rendered…
boz jennings
  • 327
  • 2
  • 6
1
vote
2 answers

Configure Schemacrawler docker via configuration file?

Schemacrawler makes reference to a "configuration file", e.g. in https://www.schemacrawler.com/diagramming.html it says: Show column ordinals, by setting configuration option schemacrawler.format.show_ordinal_numbers=true in the configuration file.…
Jon Lauridsen
  • 2,521
  • 5
  • 31
  • 38
1
vote
1 answer

schemacrawler and sqlite3 - asks for database connection URL

I'm trying to get a diagram from my sqlite3 file, a ruby-on-rails db in development. I read the docs and some other sites about how to make this happen on the command line: . ./schemacrawler.sh server=sqlite…
L.Grutz
  • 11
  • 3
1
vote
1 answer

On demand loading in Schemacrawler?

So I have a rather large database where I want to show its metadata (schemas, tables, and columns) in a tree browser (I use Schemacrawler to fetch all the DB data, and JTree for the tree). However, because there are so many tables and columns, the…
Eli
  • 69
  • 1
  • 7
1
vote
1 answer

SchemaCrawler getting Sequences from PostgreSQL database

Im using Schema 14.16.01 and running it on a PostgreSQL 9.6 database with the java api. I can't seem to get the api to get the sequence data from my PostgreSQL. I saw from a previous question that you'll need to set the info level to maximum, but…
Ken Dang
  • 13
  • 4
1
2 3 4 5 6 7 8