SQLDelight review

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

SQLDelight is an open-source code generation tool for Kotlin applications that turns SQL schema definitions and labeled SQL statements into type-safe Kotlin database APIs. It is designed for teams building Android, JVM, JavaScript, native, or Kotlin Multiplatform applications that want database structure and SQL checked during compilation. Generated database and schema classes, along with type-safe query functions, keep the output closely tied to the SQL being authored.

Its strongest angle is compile-time verification. SQLDelight verifies schemas, SQL statements, and migrations, helping surface database inconsistencies during the build rather than leaving them to runtime. Gradle plugin integration fits Kotlin build workflows, while IDE autocomplete and refactoring support extend the generated-code approach into SQL editing. The supported dialects include SQLite, MySQL, PostgreSQL, and HSQL/H2, with HSQL/H2 identified as experimental. This combination makes it a practical fit when SQL remains central to the application and correctness checks are a priority.

The trade-off is focus. SQLDelight is built around Kotlin and SQL, so teams seeking code generation across several programming languages or a broader application-scaffolding system should consider a different category of tool. Its open-source model and multiplatform coverage suit projects that want a Kotlin-native database layer across Android, iOS, desktop, web, or other supported targets. Choose SQLDelight when typed database APIs, verified migrations, Gradle integration, and IDE assistance matter; look elsewhere when Kotlin is not the target language or database code generation is only a small part of a wider generation workflow.

SQLDelight pros and cons

• Where it wins
  • Compile-time verification for schemas, queries, and migrations
  • Generates type-safe Kotlin database APIs and query functions
  • Supports Gradle, IDE features, and multiple SQL dialects
• Where it doesn't
  • Focused on Kotlin rather than multiple programming languages
  • HSQL/H2 dialect support is experimental
  • SQL-focused scope may not suit broader code-generation needs

SQLDelight fact sheet, pricing and score →

Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.

Last updated 7 Oct 2026 · How we research and update