Overview

Description

This plugin provides Security rules for PostgreSQL interaction in Node.js (SQL injection prevention). By using this plugin, you can proactively identify and mitigate security risks across your entire codebase.

Philosophy

Interlace fosters strength through integration. Instead of stacking isolated rules, we interlace security directly into your workflow to create a resilient fabric of code. We believe tools should guide rather than gatekeep, providing educational feedback that strengthens the developer with every interaction.

Getting Started

• To check out the guide, visit eslint.interlace.tools. 📚
• 要查看中文 指南, 请访问 eslint.interlace.tools. 📚
• 가이드 문서는 eslint.interlace.tools에서 확인하실 수 있습니다. 📚
• ガイドは eslint.interlace.toolsでご確認ください。 📚
• Para ver la guía, visita eslint.interlace.tools. 📚
• للاطلاع على الدليل، قم بزيارة eslint.interlace.tools. 📚

npm install eslint-plugin-pg --save-dev

💡 What You Get

• PostgreSQL-specific rules: Catches pg driver anti-patterns that generic linters miss
• LLM-optimized messages: Structured 2-line errors with CWE + fixes that AI assistants can apply
• Connection safety: Prevents leaks, double releases, and transaction race conditions
• SQL security: SQL injection, search_path hijacking, file access via COPY
• Performance patterns: N+1 queries, SELECT *, bulk operation suggestions

Every rule produces a structured error message:

src/db.ts
  42:15  error  🔒 CWE-89 OWASP:A03-Injection CVSS:9.8 | Unsafe query detected | CRITICAL
                    Fix: Use parameterized query: client.query('SELECT * FROM users WHERE id = $1', [userId])

⚙️ Configuration Presets

📚 Supported Libraries

Custom Configuration

import pg from 'eslint-plugin-pg';

export default [
  {
    plugins: { pg },
    rules: {
      'pg/no-unsafe-query': 'error',
      'pg/no-select-all': 'off', // Disable if needed
    },
  },
];

Rules

Legend

🔗 Related ESLint Plugins

Part of the Interlace ESLint Ecosystem — AI-native security plugins with LLM-optimized error messages:

📄 License

MIT © Ofri Peretz