Query SQL Databases

using Node.js and TypeScript

@databases lets you read and write data to Postgres, MySQL, SQLite and other databases in Node.js using ordinary SQL with parameters automatically escaped to prevent SQL injection.

Get started

100% free and open source

Used in production at these companies, and more

Type safe API for simple operations

await tables.users(db).insert({
  email: `janet@example.com`,
  active: true,
});

	email	active
	adam@example.com	true
	forbes@example.com	true
	dee@example.com	true
+	janet@example.com	true

await tables.users(db).update(
  {email: `dee@example.com`},
  {active: false},
);

	email	active
	adam@example.com	true
	forbes@example.com	true
⇄	dee@example.com	false
	janet@example.com	true

await tables.users(db).delete({
  email: `forbes@example.com`,
});

	email	active
	adam@example.com	true
-	forbes@example.com	true
	dee@example.com	false
	janet@example.com	true

Type safe single-table queries

await tables.users(db)
  .find({
    email: anyOf([
      `adam@example.com`,
      `janet@example.com`,
    ]),
  })
  .all();

	email	active
·	adam@example.com	true
	dee@example.com	false
·	janet@example.com	true

Use the full power of SQL to write complex queries

await db.query(sql`
  SELECT
    users.email,
    count(*) AS posts
  FROM users
  INNER JOIN posts
  ON (users.email = posts.author)
  GROUP BY users.email
  WHERE users.active = true
`);

	email	posts
	adam@example.com	4
	janet@example.com	16

Wrap any operations into an atomic transaction

await db.tx(async (db) => {
  await tables.users(db).update(
    {email: `dee@example.com`},
    {active: true},
  );
  return await db.query(sql`
    SELECT
      users.email,
      count(*) AS posts
    FROM users
    INNER JOIN posts
    ON (users.email = posts.author)
    GROUP BY users.email
    WHERE users.active = true
  `);
});

	email	posts
	adam@example.com	4
	dee@example.com	3
	janet@example.com	16

We support your database

Each supported database engine has a separate driver. This means that @databases can take advantage of the features unique to each database. Core elements are shared. This makes it quick to add support for a new database engine.

Key features

Type Safe: @databases is written in TypeScript, so every module has type safety and type definitions built in. In addition to that, we also have CLIs that let you generate types for your database tables.
Modular: Each database driver is published as a separate module. Each problem we solve get its own reusable package. This means that even if you don't want to use @databases to connect to your SQL database, you can still use our locking implementation, or our queue implementation.
Promises: All the @databases APIs are designed with promises in mind from the get go. You won't need to mess around with old callback styles. This keeps your code clean and simple.