zod-dbs-mssql

Microsoft SQL Server provider for zod-dbs.

Installation

``bash
npm install zod-dbs-mssql
`

> Note: This package has a peer dependency on mssql. If you don't already have it, you might need to install it (depending on your environment, package manager, etc):

`bash
npm install mssql
`

CLI Usage

`bash
npm install zod-dbs-cli zod-dbs-mssql

npx zod-dbs --provider mssql
`

$3

| Option | Description |
| ---------------------------- | -------------------------------------------------------------------- |
| --connection-string | Full database connection string (overrides other connection options) |
| --host | Database host (default: localhost) |
| --port | Database server port (default: 1433) |
| --user | Database user |
| --password | Database password |
| --database | Database name |
| --schema-name | Database schema to introspect |

Programmatic Usage

`ts
import { generateZodSchemas } from 'zod-dbs';
import { createProvider } from 'zod-dbs-mssql';

const provider = createProvider();

await generateZodSchemas({
provider,
config: {
// See zod-dbs documentation for available options
},
});
``