{"library":"mysql-types-generator","title":"mysql-types-generator","description":"Generates TypeScript type definitions from a MySQL database schema. v2.1.0, active development, requires Node >=18.3. Automatically converts snake_case table names to PascalCase types, supports custom suffix, column type overrides, enum string generation, and tinyint-as-boolean toggle. Outputs per-table files with index re-export or single file. Useful for Knex or raw MySQL users who want typed database schemas without an ORM. Alternatives like mysql-type-defs-generator exist but this package offers a more focused API and CLI with minimal configuration.","language":"javascript","status":"active","last_verified":"Sat Apr 25","install":{"commands":["npm install mysql-types-generator"],"cli":{"name":"mysql-types-generator","version":null}},"imports":["import { generateMysqlTypes } from 'mysql-types-generator'","const { generateMysqlTypes } = require('mysql-types-generator')","import type { GenerateOptions } from 'mysql-types-generator'"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"// file: updateTypes.js\nimport { generateMysqlTypes } from 'mysql-types-generator';\n\nconst dbConfig = {\n  host: process.env.DB_HOST ?? 'localhost',\n  port: parseInt(process.env.DB_PORT ?? '3306'),\n  user: process.env.DB_USER ?? 'root',\n  password: process.env.DB_PASSWORD ?? '',\n  database: process.env.DB_NAME ?? 'mydb',\n};\n\ngenerateMysqlTypes({\n  db: dbConfig,\n  output: { dir: 'src/types' },\n  suffix: 'PO',\n  ignoreTables: ['knex_migrations', 'knex_migrations_lock'],\n  tinyintIsBoolean: false,\n})\n  .then(() => console.log('Types generated!'))\n  .catch(err => console.error(err));","lang":"typescript","description":"Generates TypeScript types from a MySQL database, outputting each table as a PascalCase type with 'PO' suffix in separate files.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}