QuickBooks Desktop + MCP Server

Query QuickBooks
with SQL.

An ODBC driver with a built-in SQL server for your QuickBooks Desktop data. 120+ tables, real-time caching, full CRUD. Connect any SQL client, or let AI do it via MCP.

Download Free Trial Documentation →

30-day free trial · No credit card · Windows 10/11 & Server 2019+

SQL Client - localhost:5433

$ psql -h localhost -p 5433 -U qbconnect quickbooks

quickbooks=# SELECT c.name, SUM(i.total) as revenue
             FROM invoices i
             JOIN customers c ON i.customer_ref = c.list_id
             WHERE i.txn_date >= '2025-01-01'
             GROUP BY c.name
             ORDER BY revenue DESC
             LIMIT 5;

     name        │  revenue
─────────────────┼──────────
 Acme Corp       │ $45,200.00
 TechStart LLC   │ $32,750.00
 Global Trade    │ $28,400.00
 Premier Svcs    │ $19,800.00
 DataFlow Inc    │ $15,600.00
(5 rows)

quickbooks=# ▌

Built for developers

Everything you need to query, analyze, and manage QuickBooks Desktop data programmatically.

Built-in SQL Server

No driver install needed for most clients. Syntra includes a built-in SQL server on port 5433 with native connectivity for modern tools.

120+ Tables

Invoices, customers, items, bills, estimates, and more. Custom fields are auto-discovered from your QuickBooks file.

Full SQL Support

JOINs, CTEs, subqueries, aggregates, window functions. Full SQL engine built in, no external dependencies.

Smart Caching

Smart local cache with incremental sync. Adaptive polling tiers keep data fresh without hammering QuickBooks.

Read & Write

INSERT, UPDATE, DELETE directly into QuickBooks. Void transactions via SQL. Full CRUD on supported entities.

Built-in MCP Server

Let Claude, Cursor, and Windsurf query QuickBooks through natural language. 24 QuickBooks tools are exposed through MCP, including a persistent memory layer.

New

Talk to QuickBooks with AI

Built-in MCP server lets Claude, Cursor, Windsurf, and any MCP-compatible tool query and manage your QuickBooks data through natural language. Book journal entries, pull reports, create invoices. Just ask.

◆ 24 QuickBooks tools, including query, insert, update, delete, void, preview journal entries, built-in reports, and a persistent memory layer

◆ Zero config stdio. AI spawns the process, instant connection

◆ Preview before commit. Validates journal entries before writing

Learn more about MCP →

Claude + QuickBooks via MCP

You:  Show me all overdue invoices over $1,000

Claude: Let me query your QuickBooks data...

→ query: SELECT c.full_name, i.ref_number, i.balance_remaining,
         i.due_date, CURRENT_DATE - i.due_date AS days_overdue
  FROM invoices i JOIN customers c ON i.customer_ref = c.list_id
  WHERE i.due_date < CURRENT_DATE AND i.balance_remaining > 1000
  ORDER BY days_overdue DESC

Found 4 overdue invoices totaling $12,450.00:

  Acme Corp       INV-1042  $4,200.00   45 days overdue
  TechStart LLC   INV-1089  $3,750.00   32 days overdue
  Global Trade    INV-1101  $2,800.00   18 days overdue
  Premier Svcs    INV-1115  $1,700.00   12 days overdue

Works with your tools

Claude Cursor Windsurf Excel Power BI Tableau Python Node.js Prisma SQLAlchemy

How we compare

A narrower, research-backed snapshot of where Syntra clearly leads and where the tradeoffs are real.

Last verified April 8, 2026

Feature	Syntra ODBC	QODBC	CData	Devart	Lead
Modern client access without an extra SQL gateway	Built in	ODBC driver only	ODBC driver with optional remoting and gateway tooling	ODBC driver only	Syntra edge
Advanced SQL surface	JOINs, subqueries, CTEs, window functions	Standard ODBC SQL; not a relational server	SQL-92 plus complex JOINs	SQL-92 plus JOINs and subqueries	Syntra edge
SQL standards level	Beyond SQL-92	ODBC-style SQL layer	SQL-92	SQL-92	Syntra edge
Live-vs-cached control	Adaptive sync plus per-session freshness override	Optimizer cache	Smart caching and cache settings	Local caching and pooling	Syntra edge
QuickBooks-specific AI / MCP runtime	Built in, with 24 QuickBooks tools	No published MCP layer	Separate AI / MCP product line	No QuickBooks MCP surface published	Syntra edge
Client platform flexibility	Windows, macOS, and Linux client apps	Windows	Windows, Linux, and macOS	Windows	Tradeoff

See the full comparison research →

For developers

QuickBooks, with IntelliSense.

An open-source TypeScript SDK for Syntra ODBC. Pre-built Drizzle schema, zero-config client, and codegen CLI, all on npm. Full autocomplete on every QuickBooks table and column in VS Code.

Explore the SDK → GitHub

$ npm install @syntraodbc/drizzle-schema

import * as schema from '@syntraodbc/drizzle-schema';

db.select().from(schema.invoices)

.where(eq(schema.invoices.balance_remaining, 1000))

Frequently Asked Questions

Do I need to install an ODBC driver?

For most tools (Python, Node.js, ORMs), no. Syntra ODBC includes a built-in SQL server that works with standard database clients. For Excel and legacy apps, a bundled ODBC driver is included in the installer.

Does QuickBooks Desktop need to be running?

For live queries and write operations, yes. However, cached reads work even when QuickBooks is closed. The local cache serves your last synced data.

How does the MCP server work?

AI tools like Claude and Cursor spawn syntra-odbc.exe --mcp-stdio as a subprocess. The AI gets 24 tools to query, insert, update, delete, void, run built-in reports, and persist facts and aliases across sessions via the memory layer.

How fresh is the cached data?

Syntra uses four adaptive polling tiers: Hot (60s), Warm (3 min), Cold (15 min), Frozen (1 hour). Force a live query with SET QB_MAX_STALENESS = 0.

Is there a free trial?

Yes, a 30-day free trial with all features unlocked. No credit card required. Download it from our download page.

Try Syntra ODBC Free for 30 Days

Full-featured trial. No credit card required.

Download Now

Query QuickBookswith SQL.