Warehouse-grade analytics. Without the warehouse-grade bill.
GizmoSQL is the enterprise-grade DuckDB server — open-source, Apache Arrow Flight SQL.
GizmoSQL runs standard SQL on open formats you control — query terabytes in seconds at up to 90% less than Snowflake or Databricks. Self-host it in your own cloud or on-premises (or let us run it fully managed). Your data and your keys never leave your infrastructure.
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
Why Teams Switch to GizmoSQL
Warehouse-grade analytics on infrastructure you control — measured, not promised.
Same workloads, a tenth of the bill
Flat per-vCPU pricing on hardware you choose — no credits, no DBUs, no per-byte scan charges. Costs stay fixed while your usage grows.
Terabyte-scale answers on one VM
The full TPC-H 1 TB benchmark in under two minutes on a single cloud VM — about $0.17 of compute per run.
Your tools connect as-is
Arrow Flight SQL, JDBC, ADBC, and ODBC. Tableau, Power BI, dbt, DBeaver, and your notebooks keep working — same SQL, faster wire.
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 DefaultEnterprise perms
TLS encryption and authentication built in; fine-grained permissions with Enterprise
Multi-TenantEnterprise
Session management and per-catalog permissions for multi-agent deployments
Up and Running in Three Steps
No ingestion pipelines, no re-platforming project — most teams see their own data answering queries the same afternoon.
Install Core — free
Native binaries for Linux, macOS, and Windows, Docker images, or the Kubernetes operator. Running in minutes.
Point it at your data
DuckDB files, Parquet, Iceberg, Delta Lake, or DuckLake on your object storage. No ingestion, no copies, no lock-in.
Connect your tools
Your BI dashboards, dbt models, and notebooks connect over JDBC / ADBC / ODBC and just work — same SQL as before.
Runs Everywhere
From mobile to Kubernetes — native builds for every major platform
GizmoSQL Core Is Trusted Open Source
The engine underneath Enterprise isn’t a black box. GizmoSQL Core is Apache-2.0 open source — downloaded, starred, and run in production by teams worldwide. Read every line before you trust it with your data; run it free forever.
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.
How much is your warehouse overcharging you?
Enter your current compute spend and see what the same workloads cost on GizmoSQL.
~$9,000/mo on GizmoSQL vs $30,000/mo today — typical ~70% for Snowflake migrations.
Half-Bill Guarantee: at least $180,000/yr — or you don’t pay.
Get your detailed savings report
We’ll map these numbers to your actual workloads and send a migration plan — free.
Estimates are illustrative (based on typical GizmoSQL migrations) — your report uses your real workloads.
DuckDB Speed. Arrow Flight SQL Wire. Your Formats.
The two fastest open-source technologies in analytics — DuckDB’s vectorized engine and Apache Arrow’s columnar transport — fused into one hardened server.
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.
The Moment You’ll Need Enterprise
Core gets you production-grade speed for free. These are the three moments that make teams upgrade — usually in week one of a real rollout.
“Security review just blocked our rollout.”
InfoSec wants SSO, an audit trail, and least-privilege access before GizmoSQL touches production data. Enterprise ships all three — SSO/OAuth against your OIDC provider (Okta, Google, Entra), per-catalog permissions, and session-level auditing — so you pass the review instead of spending a quarter building auth yourself.
“One runaway query is eating the whole server.”
An accidental cross-join pins every core and everyone's dashboards freeze. Enterprise gives you the operational controls production demands: automatic query profiling to find it, KILL SESSION to end it, and statement queuing with timeouts so it never takes the server down again.
“Compliance is asking: who ran what, and when?”
On Core, that answer is an archaeology project through server logs. Enterprise session instrumentation records every session and statement — with timing and query plans — so the answer is a SQL query, delivered in minutes instead of weeks.
Support that scales with you
Every tier is answered by people who ship the product — support means the engineer who built it, not a ticket queue.
GitHub issues plus the GizmoData Community Slack — talk to other users and the founder directly.
Your questions answered by the engineer who built GizmoSQL. Not a ticket queue, not tier-1 triage.
Contractual response times, dedicated support, and procurement-friendly terms for larger deployments.
Instant trial key — no sales call, no card. Backed by a 30-day money-back guarantee.
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 |
Try Enterprise with zero risk
We only win when GizmoSQL earns its place in your stack — so every Enterprise license is backed by a money-back satisfaction guarantee. If it isn't a fit, you get your money back. No lock-in, no fine print, no hard feelings.
First 30 days: 100% back
Not satisfied for any reason? Ask within 30 days of purchase and we refund the full license fee — no justification required.
After 30 days: pro-rated
Change course later in your term and we refund the unused, time-based portion — you never pay for months you won't use.
Frequently Asked Questions
Everything you need to know about GizmoSQL
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
Use ADBC Connection Profiles in Python
April 15, 2026 • by Ian Cook, Columnar
Columnar's cookbook walks through ADBC connection profiles — reusable TOML connection configs — using GizmoSQL servers in Docker to stand in for dev and prod environments.
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
Run DuckDB on Your iPhone! Exploring GizmoSQL's Lightning-Fast Mobile Data Warehouse
Independent coverage of the GizmoSQL iOS app — running DuckDB as a lightning-fast mobile data warehouse, right on your iPhone.
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.
Start in Minutes. Save for Years.
Install Core free, take every Enterprise feature for a 30-day spin, or buy now — self-serve checkout, license key in minutes, backed by a 30-day money-back guarantee.