Microsoft SQL Server provider for zod-dbs
npm install zod-dbs-mssqlMicrosoft SQL Server provider for zod-dbs.
``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
`bash
npm install zod-dbs-cli zod-dbs-mssql
npx zod-dbs --provider mssql
`
| 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 |
`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
},
});
``