
Generate database documentation with SchemaSpy & Docker (Windows, Linux, macOS)
Introduction SchemaSpy is a tool that allows you to generate interactive HTML documentation from databases. In this guide, I will use Oracle as an example, but you can also use SchemaSpy with PostgreSQL, MySQL, SQL Server, etc. Thanks to Docker, you can easily run it on Windows, Linux, or macOS. Let's get started! 🚀 Prerequisites Docker installed on your system: Docker Desktop JDBC driver. Tis image includes drivers for: MySQL MariaDB PostgreSQL jTDS If you use any of these, you do not need to download any drivers. Since this guide uses Oracle Database as an example, you will need to download the Oracle JDBC driver ojdbc11.jar from the Oracle website . Getting Started Step 1: Create the working directory Open your terminal and run: mkdir schemaspy-doc && cd schemaspy-doc mkdir drivers output Step 2: Add the JDBC driver Move the downloaded driver (in this case ojdbc11.jar ) into the drivers/ folder. Step 3: Create schemaspy.properties Create a schemaspy.properties file with the followin
Continue reading on Dev.to
Opens in a new tab




