Your data warehouse is overcharging you.
GizmoSQL is a blazing-fast SQL engine on DuckDB and Apache Arrow Flight SQL. Run the same queries for up to 90% less — self-hosted in your own cloud, or fully managed by us.
100K+ Docker pulls · In production at Summation & Randoli · Featured on Product Hunt
The same SQL. Half the bill.
GizmoSQL gives you warehouse-grade analytics without the warehouse-grade invoice — on open standards you control.
Self-host or fully managed
Run GizmoSQL in your own cloud — your data and your keys never leave your infrastructure — or let us operate it for you. Same engine, your call.
Benchmarks you can reproduce
Powered by DuckDB — the #2 median hot-run on ClickBench's single-node reference benchmark, ahead of Snowflake, BigQuery, Redshift & Databricks. 1 TB TPC-H in under 2 minutes for $0.17.
Plugs into your stack
Speaks Arrow Flight SQL, ADBC, JDBC & Python; works with dbt, Iceberg, DuckLake and S3/GCS/Azure. Standard SQL, so your dashboards and queries come along.
Open by default, no lock-in
Apache-2.0 core and open table formats — no proprietary storage. Add token auth, fine-grained permissions and audit logging when you need them: enterprise controls, minus the enterprise invoice.
Our Products
Enterprise-grade data solutions built for performance, scale, and cost efficiency
The lightning-fast SQL engine powered by DuckDB and Apache Arrow Flight SQL. Process billions of rows in seconds at up to 90% lower cost than traditional platforms. Ideal for LLM and AI agent workloads — multiple agents can share a single lightweight SQL server with concurrent access. Now with Enterprise Edition for production workloads with session instrumentation, admin controls, and fine-grained permissions.
Blazing Fast
1TB in under 2 minutes
Up to 90% Savings
vs. traditional platforms
Enterprise Security
Military-grade encryption
AI Agent Ready
Shared SQL for multi-agent workflows
Apache 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
TPC-H 1TB benchmark (Core Edition):
1:49 ($0.17)
The distributed SQL engine that scales from edge devices to 1000-node clusters. Run anywhere - cloud, on-premises, or edge IoT devices.
Run Anywhere
Cloud, on-prem, or edge
1000+ Workers
Massive parallelism
Edge IoT Ready
iPhones, laptops, and more
DuckDB Core
Battle-tested engine
Distributed Architecture
1 Trillion Row Challenge
1,000 workers on Azure
GizmoData Cloud
Fully managed GizmoSQL — we run it, you just query. The speed and cost of GizmoSQL, with none of the ops.
What Our Customers Say
Trusted by teams building production infrastructure
We chose GizmoSQL to run our DuckLake compute engine in production. Phil has been an exceptional partner—delivering enterprise features we needed like token authentication, enhanced logging, and query timeouts, while providing fast, responsive support. Since partnering with GizmoData, we’ve gone live with one of our primary customers.
Ramachandran ("RC") Ramarathinam
Co-Founder & CTO
Summation — Decision-Grade AI Platform for Enterprise Leaders
GizmoSQL fits right into our stack — performant, flexible, and reliable. It’s a key piece of how we deliver unified observability at Randoli.
Latest News
Stay up to date with GizmoData announcements, events, and product updates
GizmoSQL Is Now a Built-In DBeaver Driver
As of the 26.1.0 release, GizmoSQL ships as a native driver in DBeaver — the world's most popular database GUI. No manual JDBC setup: pick GizmoSQL from the driver list, enter your connection, and start querying. Bundled and maintained upstream.
Experimental Quack JDBC Driver
A new JDBC driver for the Quack remote protocol — point any JVM tool (DBeaver, DataGrip, dbt, Spark) at a jdbc:quack:// URL and start querying a remote DuckDB server. Distributed on Maven Central. Experimental/alpha.
Latest from Our Blog
Stay updated with the latest insights, benchmarks, and developments in data analytics
Welcoming Quack: DuckDB's New Client-Server Protocol — and Where GizmoSQL Goes From Here
DuckDB Labs announced Quack, a native client-server protocol for DuckDB. A thank-you to the team — and a look at how GizmoSQL complements the growing client-server DuckDB ecosystem.
Freeing the Individuals from the Matrix: How GizmoSQL Makes Your Database AI-Agent Ready
A Matrix-themed deep dive into building an AI-agent-ready architecture with GizmoSQL, DuckDB, and Claude—simulating one million people and monitoring anomalies with an autonomous AI agent.
ADBC Flight SQL 1.10.0: Bulk Ingestion for GizmoSQL
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.
What the Heck is GizmoSQL?
A deep dive into GizmoSQL—a small server that runs DuckDB with the Arrow Flight SQL protocol wrapped around it so you can run DuckDB remotely.
Introducing GizmoSQL Operator
Announcing the GizmoSQL Kubernetes Operator—a tool to reduce operational costs of running large-scale SQL queries.
GizmoEdge Takes on the 1 Trillion Row Challenge
What happens when you give a distributed SQL engine a trillion-row dataset? GizmoEdge crushed the Coiled challenge with a 1,000-worker cluster on Azure.
GizmoSQL One-Trillion Row Challenge Results
GizmoSQL completed the 1 trillion row challenge! Learn how we processed massive datasets using DuckDB and Apache Arrow Flight SQL.
Articles
Insights and technical knowledge from our team
Powering Data APIs with Arrow Flight RPC and Ibis
October 25, 2024 • by Philip Moore
In this article, we'll demonstrate how you can use a Apache Arrow Flight RPC API server powered by Ibis to create fast, efficient data APIs.
Featured Videos
See our products 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.
GizmoEdge at the DuckDB Developer Meeting
Presenting GizmoEdge at the inaugural DuckDB Developer Meeting in Amsterdam
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!
GizmoEdge
The world's first IoT-powered distributed SQL engine
Contact Us
We know that our clients have unique needs. Get in touch, and we will get back to you soon.