sqldelight

sqldelight/sqldelight

SQLDelight - Generates typesafe Kotlin APIs from SQL

View on GitHub Website / Demo Back to listing

6.9kstars 580forks 100+contributors Kotlin

README.md

View on GitHub

# <img src="docs/images/icon-sqldelight.svg" style="height: 1em; margin-bottom: -0.1em;"> SQLDelight

See the [project website](https://sqldelight.github.io/sqldelight/) for documentation and APIs

SQLDelight generates typesafe Kotlin APIs from your SQL statements. It verifies your schema, statements, and migrations at compile-time and provides IDE features like autocomplete and refactoring which make writing and maintaining SQL simple.

SQLDelight understands your existing SQL schema.

```sql
CREATE TABLE hockey_player (
  id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  number INTEGER NOT NULL
);
```

It generates typesafe code for any labeled SQL statements.

![intro.gif](docs/images/intro.gif)

---

SQLDelight supports a variety of dialects and platforms:

SQLite

* [Android](https://sqldelight.github.io/sqldelight/android_sqlite)
* [Native (iOS, macOS, or Windows)](https://sqldelight.github.io/sqldelight/native_sqlite)
* [JVM](https://sqldelight.github.io/sqldelight/jvm_sqlite)
* [JavaScript](https://sqldelight.github.io/sqldelight/js_sqlite)
* [Multiplatform](https://sqldelight.github.io/sqldelight/multiplatform_sqlite)

[MySQL (JVM)](https://sqldelight.github.io/sqldelight/jvm_mysql/)

[PostgreSQL (JVM)](https://sqldelight.github.io/sqldelight/jvm_postgresql)

[HSQL/H2 (JVM)](https://sqldelight.github.io/sqldelight/jvm_h2) (Experimental)

## Snapshots

Snapshots of the development version (including the IDE plugin zip) are available in
[the Central Portal Snapshots repository](https://central.sonatype.com/repository/maven-snapshots/).

Documentation pages for the latest snapshot version can be [found here](https://sqldelight.github.io/sqldelight/snapshot).

License
=======

Licensed under the Apache License, Version 2.0 (the "License");
    you may not use this file except in compliance with the License.
    You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
    distributed under the License is distributed on an "AS IS" BASIS,
    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    See the License for the specific language governing permissions and
    limitations under the License.

Repository info

Default branch: main
Latest version: 2.4.1
Created: 2015-10-21
Last activity: 2026-10-06
License: Apache-2.0
Open issues: 371
Watchers: 119

Topics

kotlin-multiplatform sql sqldelight

Contributors

renovate[bot]

875 contributions

JakeWharton

571 contributions

AlecKazakova

472 contributions

hfhbd

148 contributions

griffio

144 contributions