@syntraodbc/drizzle-schema

Typed Drizzle ORM schema for every QuickBooks Desktop table exposed by Syntra ODBC. Full IntelliSense. Zero hand-written types.

Status: early access. The schema generator is being wired up. Watch the repo for the first release.

Install

npm install @syntraodbc/drizzle-schema drizzle-orm postgres

Usage

import { drizzle } from 'drizzle-orm/postgres-js';
import { eq } from 'drizzle-orm';
import postgres from 'postgres';
import * as schema from '@syntraodbc/drizzle-schema';

const db = drizzle(
  postgres('postgres://qbconnect@localhost:5433/quickbooks', {
    password: process.env.SYNTRA_PASSWORD,
  }),
  { schema }
);

// Full autocomplete on every QuickBooks table and column.
const unpaid = await db
  .select()
  .from(schema.invoices)
  .where(eq(schema.invoices.is_paid, false));

Links

• Landing page: syntraodbc.com/developers
• Drizzle integration guide: syntraodbc.com/integrations/drizzle
• Monorepo: github.com/syntraodbc/typescript-sdk
• Download Syntra ODBC: syntraodbc.com/download

License

MIT. Built by Syntra ODBC.