The SQL server built for AI agents and modern analytics
GizmoSQL is a lightweight, high-performance SQL database engine that uses DuckDB under the hood and speaks Apache Arrow Flight SQL—so your data moves fast, your agents query concurrently, and your costs stay low.
Open-source core. Enterprise-ready security. Deploy anywhere.
How GizmoSQL Works
GizmoSQL wraps DuckDB in a shared SQL server that speaks Arrow Flight SQL—giving you the speed of an embedded database with the accessibility of a network server.
Deploy GizmoSQL
Run as a native binary, Docker container, or in Kubernetes. Point it at your data and it's ready to serve queries.
Connect via Arrow Flight SQL
Use ADBC, JDBC, ODBC, or any Arrow Flight SQL client. Data moves in columnar Arrow format—fast and efficient.
Query at Scale
AI agents, BI tools, and analysts query concurrently. Authentication and permissions keep everything secure.
Everything You Need
A modern SQL server designed for today's data and AI workloads.
DuckDB-Powered Engine
Uses DuckDB as the back-end query execution engine—process terabytes of data at high speed with significantly lower costs than traditional platforms.
Apache Arrow Flight SQL
Modern columnar protocol that minimizes serialization overhead vs. JDBC or REST/JSON. Faster data transfers between clients and server, out of the box.
ADBC (Arrow Database Connectivity)
Plugs directly into Jupyter notebooks, Python-based AI agent frameworks like LangChain or CrewAI, and modern data tools with minimal configuration.
AI-Agent Ready
Shared, multi-tenant SQL server that enables multiple AI agents to concurrently query the same data with authentication and fine-grained permissions.
Flexible Deployment
Deploy as a native binary, Docker container, Kubernetes cluster, or even as a native iOS app on iPhone and iPad for prototyping and development.
Enterprise Security
Middleware-based authentication with TLS encryption, JWT support, and fine-grained permissions in the Enterprise Edition.
BI Tool Compatible
Works with Tableau, Apache Superset, Si-Sense, and other standard BI tools via JDBC, ODBC, and ADBC drivers.
gRPC Transport
Low-latency, asynchronous communication ideal for concurrent agent workloads and high-throughput analytics.
Open Source Core
Core edition is free and open-source under the Apache 2.0 license. Enterprise edition available for advanced security and permissions.
GizmoSQL vs Traditional SQL Servers
See how GizmoSQL stacks up against traditional approaches.
| Feature | Traditional | GizmoSQL |
|---|---|---|
| Query Engine | Custom or proprietary | DuckDB (battle-tested, blazing fast) |
| Wire Protocol | JDBC / REST / JSON | Apache Arrow Flight SQL (columnar) |
| Serialization Overhead | High (row-based) | Minimal (Arrow columnar format) |
| AI Agent Support | ❌ Not designed for agents | ✅ Multi-tenant, concurrent queries |
| Deployment Options | Server / VM | Binary, Docker, K8s, iOS |
| Authentication | Basic / LDAP | TLS, JWT, fine-grained permissions |
| BI Tool Support | JDBC / ODBC | JDBC, ODBC, and ADBC |
| License | Commercial | Apache 2.0 (Core) |
Built For
From AI agent orchestration to interactive dashboards—GizmoSQL handles it all.
Ready to supercharge your SQL?
Learn more about GizmoSQL at GizmoData, or talk to us about integration and managed services.