Skills
.Work. You
Rest

sql-guardrails

Official

Enforces safe, compliant SQL for backend.

Software Engineering#backend#sql#guardrails#coalesce#parameter-binding#enum-normalization
Authorsgpropertyanalytics
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Backend SQL and data-access guardrails are essential to prevent common mistakes when writing or modifying SQL queries, service functions, or route handlers. This guardrail helps enforce best practices that reduce bugs, security risks, and contract drift.

Core Features & Use Cases

  • Parameter style enforcement using only :param bind syntax to prevent psycopg2-style placeholders
  • Date handling with Python objects to avoid string dates and type casting issues
  • Enum normalization via contract_schema.py to ensure consistent DB values
  • Outlier filtering with COALESCE to safely ignore missing booleans
  • v2 API compliance checks to support dual-mode or camelCase responses

Quick Start

Install or enable the sql-guardrails guard before backend changes to automatically validate and enforce SQL patterns and API contracts.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sql-guardrails
Download link: https://github.com/sgpropertyanalytics/sg-property-analytics/archive/main.zip#sql-guardrails

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.