# eslint-plugin-sql-template

> ESLint plugin with rules for using the `sql` template tag on raw SQL queries

Latest version **3.2.0** (published 2026-02-13) · MIT license · 0 weekly downloads

## Install

```sh
npm install eslint-plugin-sql-template
pnpm add eslint-plugin-sql-template
yarn add eslint-plugin-sql-template
bun add eslint-plugin-sql-template
```

## Health

**Score 50/100 (C)** — status: stable.

Positive: no vulnerabilities; has provenance.

Warnings: low downloads; no types; no esm support.

## Facts

| | |
|---|---|
| Version | 3.2.0 |
| Published | 2026-02-13 |
| First published | 2016-10-03 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Node | >=20 |
| Dependencies | 0 |
| Unpacked size | 7.9 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| Provenance | attested (GitHub Actions) |
| GitHub stars | 9 |
| Author | Uphold |
| Maintainers | botatuphold, ruimarinho, fixe |
| Keywords | plugin, eslint, lint, shared, tag, sql, sql-tag, string, template |

## Links

- npm: https://www.npmjs.com/package/eslint-plugin-sql-template
- Repository: https://github.com/uphold/eslint-plugin-sql-template
- Homepage: https://github.com/uphold/eslint-plugin-sql-template#readme
- Issues: https://github.com/uphold/eslint-plugin-sql-template/issues
- npm.io page: https://npm.io/package/eslint-plugin-sql-template

## Alternatives

- [eslint-plugin-sonarjs](https://npm.io/package/eslint-plugin-sonarjs.md) — 2.9M weekly downloads
- [eslint-config-expo](https://npm.io/package/eslint-config-expo.md) — 1.5M weekly downloads
- [@matter/protocol](https://npm.io/package/@matter/protocol.md) — 63.5K weekly downloads
- [@eventcatalog/linter](https://npm.io/package/@eventcatalog/linter.md) — 24.8K weekly downloads
- [@pandacss/eslint-plugin](https://npm.io/package/@pandacss/eslint-plugin.md) — 18.7K weekly downloads

## Recent versions

- 3.2.0 (latest) — 2026-02-13
- 3.1.0 — 2025-03-20
- 3.0.0 — 2024-10-16
- 2.0.0 — 2016-10-03

## README

# eslint-plugin-sql-template

ESLint plugin with rules for using the `sql` template tag from a library such as [sql-tag](https://github.com/ruimarinho/sql-tag) on raw SQL queries.

That library escapes data provided to an SQL query statement via interpolation. This prevents, for instance, potential SQL injection attacks.

This ESLint plugin helps teams enforce the usage of that tag, to avoid overlooked vulnerabilities from creeping into their codebases.

## Status

[![npm version][npm-image]][npm-url]
[![build status][ci-image]][ci-url]

## Installation

```sh
npm install eslint eslint-plugin-sql-template --save-dev
```

## Usage

Add `sql-template` to both the `plugins` and `rules` sections of your `ESLint` configuration file. Example:

```js
// eslint.config.js
import sqlTemplate from 'eslint-plugin-sql-template';

module.exports = [
  {
    plugins: {
      'sql-template': sqlTemplate
    },
    rules: {
      'sql-template/no-unsafe-query': 'error'
    }
  }
];
```

## Rules

This plugin includes the following list of rules.

### `no-unsafe-query`

Disallows the usage of raw SQL templates with interpolation when not protected with the `sql` tag. Use this rule when you want to enforce protection against SQL injection attacks on all queries.

#### Example

Examples of **incorrect** code for this rule:

```js
/*eslint sql-template/no-unsafe-query: "error"*/

const value = 42;
const query = `SELECT * FROM users WHERE id = ${value}`;
db.query(query);

const columns = 'id, name';
Users.query(`SELECT ${columns} FROM users`);
```

Examples of **correct** code for this rule:

```js
/*eslint sql-template/no-unsafe-query: "error"*/

const value = 42;
const query = sql`SELECT * FROM users WHERE id = ${value}`;
db.query(query);

Users.query(`SELECT id, name FROM users`);

const punctuation = '!';
foo.bar(`Not SQL${punctuation}`);
```

## License

[MIT](https://opensource.org/licenses/MIT)

## Contributing

### Development

Install dependencies:

```sh
npm i
```

Run tests:

```sh
npm run test
```

### Cutting a release

The release process is automated via the [release](https://github.com/uphold/eslint-plugin-sql-template/actions/workflows/release.yaml) GitHub workflow. Run it by clicking the "Run workflow" button.

[npm-image]: https://img.shields.io/npm/v/eslint-plugin-sql-template.svg
[npm-url]: https://www.npmjs.com/package/eslint-plugin-sql-template
[ci-image]: https://github.com/uphold/eslint-plugin-sql-template/actions/workflows/ci.yaml/badge.svg?branch=master
[ci-url]: https://github.com/uphold/eslint-plugin-sql-template/actions/workflows/ci.yaml

---
_Source: https://npm.io/package/eslint-plugin-sql-template · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._
