#typescript #postgresql #mysql #sqlite #json-file

bin+lib ts_sqlx

Typescript SQLx compile-time checked queries without a DSL

3 releases

0.1.2 Feb 11, 2024
0.1.1 Feb 10, 2024
0.1.0 Feb 4, 2024

#773 in Database interfaces


1.5K SLoC


license API Crate

Typescript SQLx compile-time checked queries without a DSL.

Getting started

install the ts-sqlx cli tool globally

cargo install ts_sqlx

in your project install the typescript definitions

npm install ts-sqlx -D

include the path to generated declaration files in your tsconfig.json

  // default destination of declaration files
  "include": [".ts-sqlx/*"]

create a .env file with DATABASE_URL set to your database url


or create a .ts-sqlx.json file like

  "databases": {
    "default": "postgres://postgres:postgres@localhost:5432/postgres",
    "another": "postgres://postgres:postgres@localhost:5432/postgres"
  // defaults shown below, the rest of these are optional
  "src": ".",
  "dest": ".ts-sqlx",
  "extensions": ["ts", "tsx", "js", "jsx"],
  "ignore_patterns": ["*.d.ts"]

run in watch mode ts-sqlx watch in the root of your project, just once with ts-sqlx run or for help ts-sqlx help

see example for a "full" project example



~629K SLoC