# 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)