Knex Schema Reader

Knex Schema Reader is a utility for exporting a database schema to an object (API) and/or json file (CLI)

Features

Exports a database schema to either an object (api) or to a json file (cli). Useful in a code generation pipeline or to build tooling.

Supported database dialects:

• mssql
• mysql
• postgresql
• oracle

Sample Outputs

• SQL Server samples:

  • AdventureWorks 2014
    • Get the database
  • Northwind
    • Get the database

• MySQL samples:

  • Sakila JSON output file
    • Get the database
  • Employees JSON output file
    • Get the database

• PostgreSQL samples:

  • Pagila JSON output file
    • Get the database
  • SportsDB JSON output file
    • Get the database