# Syntra ODBC

> Syntra ODBC is a QuickBooks Desktop ODBC driver and built-in SQL server. It exposes 120+ QuickBooks tables over standard SQL on port 5433, supports JOINs, CTEs, and window functions, and provides full read and write (INSERT/UPDATE/DELETE) plus a built-in MCP server so AI tools like Claude, Cursor, and Windsurf can query QuickBooks through natural language.

Syntra ODBC runs on Windows 10/11 and Windows Server 2019+. It works with QuickBooks Pro, Premier, and Enterprise (2018 and newer). Standard plan is $299 USD/year, Pro is $499 USD/year, with a 30-day free trial requiring no credit card. Built and operated by Tradeline Consulting Inc.

## Product

- [Homepage](https://syntraodbc.com/): Overview of Syntra ODBC, features, and how it compares to other QuickBooks Desktop ODBC drivers.
- [Pricing](https://syntraodbc.com/pricing/): Standard ($299/yr USD) and Pro ($499/yr USD) plans with 30-day free trial.
- [Download](https://syntraodbc.com/download/): Windows installer (~39 MB), version 0.1.5, free 30-day trial with all features unlocked.
- [Compare](https://syntraodbc.com/compare/): Feature-by-feature comparison vs QODBC, CData, and Devart.
- [FAQ](https://syntraodbc.com/faq/): Setup, licensing, compatibility, security, and troubleshooting answers.
- [Changelog](https://syntraodbc.com/changelog/): Release notes and version history.

## Features

- [MCP Server](https://syntraodbc.com/mcp/): Built-in MCP server with 24 QuickBooks tools, persistent memory layer, and zero-config stdio for Claude, Cursor, Windsurf, and any MCP-compatible AI.
- [Native Report Builder](https://syntraodbc.com/native-report-builder/): Interactive builder for valid QuickBooks Desktop native report calls (qb_report) with date macros, filters, and output modes.
- [TypeScript SDK (Developers)](https://syntraodbc.com/developers/): Open-source TypeScript SDK on npm with typed Drizzle schema, zero-config client, and codegen CLI for full IntelliSense on every QuickBooks table.

## Integrations

- [Integrations index](https://syntraodbc.com/integrations/): All supported tools and SDKs.
- [Excel](https://syntraodbc.com/integrations/excel/): Connect Excel via ODBC Data Source or Power Query.
- [Power BI](https://syntraodbc.com/integrations/power-bi/): PostgreSQL connector with Import or DirectQuery mode.
- [Tableau](https://syntraodbc.com/integrations/tableau/): PostgreSQL connector with Live or Extract mode.
- [Python](https://syntraodbc.com/integrations/python/): pyodbc, SQLAlchemy, or pandas examples.
- [Node.js](https://syntraodbc.com/integrations/nodejs/): pg package with async/await and connection pooling.
- [Prisma](https://syntraodbc.com/integrations/prisma/): Prisma ORM via PostgreSQL data source.
- [Drizzle ORM](https://syntraodbc.com/integrations/drizzle/): Drizzle ORM via postgres-js driver.
- [SQLAlchemy](https://syntraodbc.com/integrations/sqlalchemy/): Engine creation, sessions, and automap_base.

## Documentation

- [Getting Started: Installation](https://syntraodbc.com/getting-started/installation/)
- [Getting Started: First Connection](https://syntraodbc.com/getting-started/first-connection/)
- [Getting Started: QuickBooks Setup](https://syntraodbc.com/getting-started/quickbooks-setup/)
- [Getting Started: Configuration](https://syntraodbc.com/getting-started/configuration/)
- [Getting Started: Activation](https://syntraodbc.com/getting-started/activation/)
- [Connecting: ODBC Driver](https://syntraodbc.com/connecting/odbc-driver/)
- [Connecting: SQL Server (built-in, port 5433)](https://syntraodbc.com/connecting/sql-server/)
- [Connecting: Connection Strings](https://syntraodbc.com/connecting/connection-strings/)
- [Connecting: MCP Server](https://syntraodbc.com/connecting/mcp-server/)
- [SQL Reference](https://syntraodbc.com/sql/)
- [Tables Reference (120+ QuickBooks tables)](https://syntraodbc.com/tables/)
- [Troubleshooting](https://syntraodbc.com/troubleshooting/)

## Blog

- [Syntra ODBC Blog](https://syntraodbc.com/blog/): Tutorials, announcements, and insights about QuickBooks Desktop SQL access.

## Company

- [Contact](https://syntraodbc.com/contact/): Support, sales, and partnership inquiries.
- [Privacy Policy](https://syntraodbc.com/privacy/)
- [Terms of Service](https://syntraodbc.com/terms/)
- [End User License Agreement](https://syntraodbc.com/eula/)
- [Refund Policy](https://syntraodbc.com/refund-policy/)