$ sql-db-schema-parser

Parse the text output of a MSSQL database export into JSON.

:cloud: Installation

You can install the package globally and use it as command line tool:

# Using npm
npm install --global sql-db-schema-parser

# Using yarn
yarn global add sql-db-schema-parser

Then, run sql-db-schema-parser --help and see what the CLI tool can do.

$ sql-db-schema-parser --help
Usage: sql-db-schema-parser [options]

Parse the text output of a MSSQL database export into JSON.

Options:
  -i, --input <input>  The input file.
  -h, --help           Displays this help.
  -v, --version        Displays version information.

Examples:
  $ sql-db-schema-parser --input schema.sql

Documentation can be found at https://github.com/IonicaBizau/sql-db-schema-parser#readme.

:clipboard: Example

Here is an example how to use this package as library. To install it locally, as library, you can use npm install sql-db-schema-parser (or yarn add sql-db-schema-parser):

const sqlDbSchemaParser = require("sql-db-schema-parser");

const schema = sqlDbSchemaParser.parse(`
table_name                                                                                                                       column_name                                                                                                                      data_type                                                                                                                        max_length precision scale is_nullable
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ---------- --------- ----- -----------
users                                                                                                                            email                                                                                                                            varchar                                                                                                                          42         10        0     0
users                                                                                                                            first_name                                                                                                                       varchar                                                                                                                          42         10        0     0
`);

console.log(schema);

:question: Get Help

There are few ways to get help:

1. Please post questions on Stack Overflow. You can open issues with questions, as long you add a link to your Stack Overflow question.
2. For bug reports and feature requests, open issues. :bug:
3. For direct and quick help, you can use Codementor. :rocket:

:memo: Documentation

For full API reference, see the DOCUMENTATION.md file.

:yum: How to contribute

Have an idea? Found a bug? See how to contribute.

:sparkling_heart: Support my projects

I open-source almost everything I can, and I try to reply to everyone needing help using these projects. Obviously, this takes time. You can integrate and use these projects in your applications for free! You can even change the source code and redistribute (even resell it).

However, if you get some profit from this or just want to encourage me to continue creating stuff, there are few ways you can do it:

• Starring and sharing the projects you like :rocket:

• —I love books! I will remember you after years if you buy me one. :grin: :book:

• —You can make one-time donations via PayPal. I'll probably buy a ~~coffee~~ tea. :tea:

• —Set up a recurring monthly donation and you will get interesting news about what I'm doing (things that I don't share with everyone).

• Bitcoin—You can send me bitcoins at this address (or scanning the code below): 1P9BRsmazNQcuyTxEqveUsnf5CERdq35V6

  

Thanks! :heart:

:scroll: License

MIT © Ionică Bizău