# GizmoSQL

> Self-hosted SQL server on DuckDB/SQLite with Arrow Flight SQL, TLS, JWT auth. Core is Apache 2.0; Enterprise adds SSO, metrics, permissions.

- **Category:** Databases
- **Licence:** Other
- **Latest version:** v1.42.2
- **Open source:** open_core
- **Languages:** C++
- **Platforms:** Docker, Kubernetes, Linux, Windows, iOS, Homebrew, Build from Source
- **Tags:** Analytics, SQLite, iOS, Data Warehouse, Duckdb, Databases, Sqlalchemy, SQL, Tls, Kubernetes, Olap, JWT, Jwt authentication, Jdbc, Databases, Sqlite3, Apache Arrow, Arrow Flight SQL, Adbc, Ibis, Apache Arrow Flight, Apache Arrow Flight Sql, Pyarrow, Gizmodata, Gizmosql

## Description

GizmoSQL runs on DuckDB or SQLite and serves data through Apache Arrow Flight SQL. It provides TLS/mTLS encryption, password and JWT authentication, and deploys via Docker, native binaries, Homebrew, Windows MSI, or iOS app. The free Core edition (Apache 2.0) includes dual backends, Flight SQL, TLS, JWT, and query timeout. The paid Enterprise tier adds SSO/OIDC, Prometheus metrics, session instrumentation, per-catalog permissions, kill session, and statement queuing. Clients include JDBC, ADBC, SQLAlchemy, Ibis, Python, and a psql-like CLI. It works with DBeaver, Tableau, Power BI, Grafana, Superset, and dbt. The project is now in maintenance mode, succeeded by Hardcharger.

## Links

- [Homepage](https://github.com/gizmodata/gizmosql)
- [Website](https://gizmodata.com/gizmosql)
- [Docker](gizmodata/gizmosql)
- [Demo](https://gizmosql.gizmodata.com)
- [Documentation](https://docs.gizmosql.com)
- [GitHub Repository](https://github.com/gizmodata/gizmosql)
- [Docker Hub](https://hub.docker.com/r/gizmodata/gizmosql)
- [Docker Hub LTS](https://hub.docker.com/r/gizmodata/gizmosql-lts)
- [GitHub Container Registry](https://github.com/gizmodata/gizmosql/pkgs/container/gizmosql)
- [Slack Community](https://join.slack.com/t/gizmodatacommunity/shared_invite/zt-42jk7kdti-SJp7qk7d6XYCIKfBG~4HrA)
- [JDBC Driver Download](https://github.com/gizmodata/gizmosql-jdbc-driver/releases/latest/download/gizmosql-jdbc-driver.jar)
- [ADBC Driver (PyPI)](https://pypi.org/project/adbc-driver-gizmosql/)
- [SQLAlchemy Dialect (PyPI)](https://pypi.org/project/sqlalchemy-gizmosql-adbc-dialect/)
- [Ibis Backend (PyPI)](https://pypi.org/project/ibis-gizmosql/)

---
Source: https://selfhost.directory/project/gizmosql