{"id":46857,"library":"zod-dbs-sqlite","title":"zod-dbs-sqlite","description":"An SQLite provider for zod-dbs, a tool that generates Zod schemas from your database schema. Version 1.0.5, actively maintained. It leverages better-sqlite3 to introspect SQLite database files (including :memory:) and produce type-safe Zod schemas for validation. Differentiates by being a first-party provider for zod-dbs, tightly integrated with its configuration and CLI.","status":"active","version":"1.0.5","language":"javascript","source_language":"en","source_url":"https://github.com/msunbay/zod-dbs","tags":["javascript","zod","zod-dbs","typescript","database","schema","sqlite","sqlite3","embedded"],"install":[{"cmd":"npm install zod-dbs-sqlite","lang":"bash","label":"npm"},{"cmd":"yarn add zod-dbs-sqlite","lang":"bash","label":"yarn"},{"cmd":"pnpm add zod-dbs-sqlite","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Peer dependency required for SQLite database connection and introspection.","package":"better-sqlite3","optional":false}],"imports":[{"note":"ESM-only package; CommonJS require is not supported.","wrong":"const createProvider = require('zod-dbs-sqlite').createProvider","symbol":"createProvider","correct":"import { createProvider } from 'zod-dbs-sqlite'"},{"note":"Config is a type, not a runtime value.","wrong":"import { Config } from 'zod-dbs-sqlite'","symbol":"type Config","correct":"import type { Config } from 'zod-dbs-sqlite'"},{"note":"Default export is not supported; use named export createProvider instead.","wrong":"import { default } from 'zod-dbs-sqlite'","symbol":"default export","correct":"import provider from 'zod-dbs-sqlite'"}],"quickstart":{"code":"import { generateZodSchemas } from 'zod-dbs';\nimport { createProvider } from 'zod-dbs-sqlite';\n\nconst provider = createProvider();\n\nawait generateZodSchemas({\n  provider,\n  config: {\n    database: process.env.SQLITE_DB_PATH ?? ':memory:',\n    outputDir: './zod-schemas',\n  },\n});","lang":"typescript","description":"Demonstrates programmatic usage: creating a provider and generating Zod schemas from a SQLite database."},"warnings":[{"fix":"Run: npm install better-sqlite3@>=11","message":"The package expects better-sqlite3 >=11 installed separately as a peer dependency.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Use import syntax or ensure your project is ESM (e.g., type: 'module' in package.json).","message":"ESM-only package; does not support CommonJS require().","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Omit arguments; configuration is passed via config in generateZodSchemas.","message":"The createProvider() function does not accept any arguments in the current version.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Check zod-dbs CLI documentation for --config-file option or use programmatic API.","message":"CLI usage via npx zod-dbs --provider sqlite requires additional configuration; documentation may be outdated.","severity":"deprecated","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.0.5':23 'activ':24 'better':29 'better-sqlite3':28 'cli':65 'configur':63 'databas':20,34,72 'dbs':3,11,58,70 'differenti':47 'embed':76 'file':35 'first':52 'first-parti':51 'generat':15 'includ':36 'integr':60 'introspect':32 'javascript':66 'leverag':27 'maintain':25 'memori':37 'parti':53 'produc':39 'provid':7,54 'safe':42 'schema':17,21,44,73 'sqlite':4,6,33,74 'sqlite3':30,75 'tight':59 'tool':13 'type':41 'type-saf':40 'typescript':71 'valid':46 'version':22 'zod':2,10,16,43,57,67,69 'zod-db':9,56,68 'zod-dbs-sqlit':1","created_at":"2026-06-07T13:01:58.163463+00:00","updated_at":"2026-06-07T13:01:58.163463+00:00","problems":[{"fix":"npm install better-sqlite3","cause":"Missing peer dependency better-sqlite3.","error":"Cannot find module 'better-sqlite3'"},{"fix":"Add 'type': 'module' to package.json or switch to .mjs extension.","cause":"Using import in a CommonJS project without ESM support.","error":"SyntaxError: Cannot use import statement outside a module"},{"fix":"Use: import { createProvider } from 'zod-dbs-sqlite'","cause":"Importing the default export instead of named export.","error":"TypeError: createProvider is not a function"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/msunbay/zod-dbs#readme","github":"https://github.com/msunbay/zod-dbs","docs":null,"changelog":null,"pypi":null,"npm":"zod-dbs-sqlite","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-07","next_check":"2026-09-05","install_tag":null}}