The enterprise-grade DuckDB server
GizmoSQL is an open-source Arrow Flight SQL engine powered by DuckDB — warehouse-grade analytics at up to 90% less, self-hosted in your cloud or fully managed.
100K+ Docker pulls · In production at Summation & Randoli · Featured on Product Hunt
$ gizmosql_server --database-filename lakehouse.dbApache Arrow version: 23.0.0
DuckDB version: v1.4.4
GizmoSQL version: v1.16.0
Edition: Enterprise
Server started on grpc+tls://0.0.0.0:31337
GizmoSQL Editions
Core is free and open-source. Enterprise adds the governance, auth, and support layer production teams need — for a fraction of your old warehouse bill.
Core
Apache 2.0
Enterprise
pay for the cores you run · $1,500/yr floor per server
~2 months freeReplace a $30,000/mo warehouse workload with ~$3,000/mo all-in — the GizmoSQL license on a 16-vCPU server is about $400/mo of that ($4,800/yr on the annual plan; $480/mo month-to-month). You pay under 2% of your old bill to delete the other 90%+.
Enterprise+ — Custom
Volume pricing, custom SLAs, and dedicated support.
Feature Comparison
| Feature | Core | Enterprise |
|---|---|---|
| Open-source (Apache 2.0) | ||
| Deploy in your cloud / VPC | ||
| DuckDB or SQLite backend | ||
| Arrow Flight SQL | ||
| TLS / mTLS + JWT auth | ||
| Community support | ||
| SSO / OAuth | ||
| Session instrumentation & auditing | ||
| Automatic query profiling | ||
| KILL SESSION | ||
| Per-catalog permissions | ||
| Statement queuing | ||
| Priority support | ||
| Roadmap influence |
Unparalleled Performance/Cost Ratio
GizmoSQL can run your analytic workloads with outstanding performance for up to 90% less.
Performance
GizmoSQL runs the TPC-H benchmark for 1 Terabyte in less than 2 minutes on a single cloud VM for pennies in compute cost!
Flexibility
Self-host GizmoSQL in your Cloud, or in your VPC for free - or let GizmoData host it for you for a low monthly cost. Runs on Linux, macOS, and Windows with native executables and Docker images. Choose DuckDB or SQLite as your data engine back-end.
Compatibility
Works with Tableau, Apache Superset, Si-Sense and more! Use from JupyterLab notebooks with ADBC, JDBC, and ODBC drivers.
DuckDB is great for in-process analytics — but AI agents working together need a shared, concurrent SQL server. GizmoSQL bridges that gap: a lightweight, high-performance server that multiple LLM agents can query concurrently.
Concurrent Access
Multiple agents query simultaneously via Arrow Flight SQL
Python ADBC Driver
Easy integration with LangChain, CrewAI, and other agent frameworks
Secure by Default
TLS encryption, authentication, and fine-grained permissions
Multi-Tenant
Session management and permissions for multi-agent deployments
Runs Everywhere
From mobile to Kubernetes — native builds for every major platform
Enterprise Services
GizmoData offers professional services to help you maximize your GizmoSQL deployment.
Support Services
Get expert support for your GizmoSQL deployment with our comprehensive support packages and SLA options.
Custom Solutions
We build tailored analytics solutions using GizmoSQL to meet your specific business requirements and use cases.
Enterprise Architecture
Our architects help design and implement enterprise-scale GizmoSQL deployments with optimal performance and security.
Results measured in runtime (s) and cost ($) — lower is better for both
GizmoSQL delivers excellent performance at a fraction of the cost compared to other solutions.
Powered by Cutting-Edge Technology
GizmoSQL combines the power of DuckDB, Apache Arrow Flight SQL, and enterprise-grade security.
Works with Your Data
Because it is powered by DuckDB, GizmoSQL allows you to work with many data formats including:
Easy to Use
GizmoSQL is extremely simple to install. It is statically compiled, with all libraries baked into a single executable. Administration is simple, and setup is a breeze.
The Power of Flight SQL
With GizmoSQL, you can run DuckDB remotely and securely – and use it from virtually any client.
# Connect using SQL-- Connect to GizmoSQL server
CONNECT TO 'jdbc:gizmosql://gizmosql.example.com:31337'
USER 'user' PASSWORD '...';# Run a querySELECT * FROM sales LIMIT 10;Scale out across a cluster of nodes
Run a pool of GizmoSQL servers behind Kubernetes and spread user sessions across them round-robin. Add nodes to add concurrency — in both Core and Enterprise.
GizmoSQL node 1
own sessions
GizmoSQL node 2
own sessions
GizmoSQL node 3
own sessions
GizmoSQL node 4
own sessions
Each node runs queries independently — a single query never spans nodes — while every node shares one DuckLake, with PostgreSQL keeping the catalog consistent. Scale concurrency by adding nodes.
User sessions are distributed round-robin across every node in the pool.
Each query runs entirely on one node — no cross-node coordination to slow it down.
Kubernetes-native: add or remove capacity by changing a replica count.
Same behavior in Core (Apache-2.0) and Enterprise Edition — no special tier required.
One shared DuckLake — a single open copy of your data, not a silo per node.
A PostgreSQL catalog keeps table metadata consistent across every node.
Ecosystem of Integrations
GizmoSQL connects seamlessly with your favorite tools and frameworks
Hover over any tool to see its name
Integrations & Adapters
Connect GizmoSQL with your favorite data tools and frameworks
Trusted in Production
GizmoSQL is used by customers in production to power critical data infrastructure
As a startup building a decision-grade AI platform for strategic planning, we process analytical workloads that demand both performance and reliability. After evaluating our options, we chose GizmoSQL to run our DuckLake compute engine in production. What sets GizmoSQL apart is the partnership. When we came to Phil with enterprise requirements—token authentication, enhanced logging, and query timeout support—he worked closely with us to deliver them. His responsiveness has been equally impressive. Whether fielding questions or shipping fixes for issues we’ve encountered, Phil consistently delivers with quick turnarounds. That kind of support is invaluable for a fast-moving team. Since partnering with GizmoData, we’ve gone live in production with one of our primary customers. GizmoSQL has become a critical part of our infrastructure, and we look forward to continuing the partnership.
GizmoSQL fits right into our stack — performant, flexible, and reliable. It’s a key piece of how we deliver unified observability at Randoli.
Built for Enterprise
A governed gateway to your data — scoped access, strong identity, and full auditability, so every team gets exactly the data they need and nothing they shouldn't.
Strong Identity
Authenticate every connection with SSO / OAuth, mutual TLS, or JWT — backed by any OIDC provider like Google or Okta. No shared logins, no client-side secrets.
Fine-Grained Authorization
Per-catalog, per-user permissions and true multi-tenancy with per-tenant resource limits. Give each team exactly the access they need — read, write, or none — on only the catalogs they should see.
Control & Auditability
Session instrumentation records who ran what, and when, while automatic query profiling captures the timing and plan of every statement. Keep deployments healthy with KILL SESSION, statement queuing, and query timeouts — the operational controls production demands.
Works with the tools you already run
GizmoSQL speaks Arrow Flight SQL, JDBC, and ADBC — so your existing BI, ETL, notebook, and orchestration tools connect on day one, with mature client libraries in nearly every language.
One server, two backends
Run the same secure server interface over DuckDB or SQLite — for terabyte-scale analytics, embedded and edge deployments, or anywhere SQLite's footprint and ubiquity matter.
See the Enterprise controls on your own workload — free for 30 days.
Run a GizmoSQL Server from your iPhone or iPad
GizmoSQL is now on the Apple App Store. Spin up a real Arrow Flight SQL server on iOS in seconds — perfect for development, experimentation, and learning on the go.
Runs on Almost Anything
From cloud VMs to containers to an iPhone in your pocket — GizmoSQL is built to be incredibly flexible.
Built for Learning
Explore Arrow Flight SQL, test client integrations, and prototype queries without standing up any infrastructure.
Development & Demos
Ideal for dev and learning — not intended for production workloads, but perfect for showing what the engine can do.
GizmoSQL Articles
Deep dives into the technology powering GizmoSQL
ADBC Flight SQL 1.10.0: Bulk Ingestion for GizmoSQL
January 10, 2026 • by GizmoData Team
The new ADBC Flight SQL Python driver 1.10.0 brings bulk ingestion to Arrow Flight SQL servers like GizmoSQL. Load millions of rows directly from Python or DuckDB with automatic schema inference.
GizmoSQL One-Trillion Row Challenge Results
July 15, 2025 • by GizmoData Team
GizmoSQL completed the 1 trillion row challenge! Learn how we processed massive datasets using DuckDB and Apache Arrow Flight SQL.
GizmoSQL Videos
Watch GizmoSQL's performance in action
TPC-H Benchmarks on GizmoSQL iOS, Fast 🚀
Running TPC-H benchmarks on GizmoSQL iOS — see the blazing-fast performance.
Introducing the New GizmoSQL iOS App
See the brand-new GizmoSQL iOS app, now available on the Apple App Store.
Introducing the New Windows Release of GizmoSQL
We demonstrate how easy it is to run GizmoSQL - now available for Windows.
GizmoSQL in Action
Run 10 TPC-H SF100GB benchmarks, at the same time! See GizmoSQL's lightning-fast performance.
Frequently Asked Questions
Everything you need to know about GizmoSQL
Get Started with GizmoSQL
Experience the best combination of performance and total cost of ownership. Don't overpay for lightning-fast analytics. Now available as open-source software for self-hosting.
Need enterprise support, custom solutions, or architecture services? GizmoData provides professional services to help you succeed with GizmoSQL.