@syntraodbc/client

Zero-config typed TypeScript client for Syntra ODBC. A thin strongly-typed wrapper over postgres.js with IntelliSense on every QuickBooks Desktop table and column.

Status: early access. The client surface is being built out. Watch the repo for the first release.

Install

npm install @syntraodbc/client

Usage

import { createClient } from '@syntraodbc/client';

const syntra = createClient({ password: process.env.SYNTRA_PASSWORD });

// Table names and columns autocomplete from the live QuickBooks schema.
const rows = await syntra
  .table('invoices')
  .select('ref_number', 'balance_remaining', 'due_date')
  .where({ is_paid: false });

Default connection options match the documented Syntra setup: host: 'localhost', port: 5433, database: 'quickbooks', user: 'qbconnect'.

Links

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

License

MIT. Built by Syntra ODBC.