Sql Formatter

Format, minify, and lint SQL queries from the command line. Formats SQL with proper indentation and keyword casing, minifies by removing whitespace and comme...

Security Scan

The skill's code and instructions are coherent with its stated purpose (a local SQL formatter/linter) and it does not request credentials or external installs, though the provided source was partially truncated so a final check of the full file is prudent.

Purpose & Capability

Name/description match the included Python script and SKILL.md. The skill formats, minifies, and lints SQL using a local Python script; no unexpected services, credentials, or binaries are required.

Instruction Scope

SKILL.md instructs the agent/user to run scripts/sql_format.py against provided SQL (files or stdin). The instructions reference only input/output paths and formatting options — they do not ask the agent to read unrelated files, environment variables, or contact external endpoints.

Install Mechanism

No install spec; this is instruction-only with an included Python script. That is proportionate for a pure-Python, zero-dependency tool.

Credentials

No environment variables, credentials, or config paths are requested. The script imports only standard-library modules (argparse, re, sys, json) and processes supplied files/STDIN — proportional to the stated functionality.

Persistence & Privilege

Skill does not request always:true and does not modify other skills or system settings. It runs on-demand using a local script, which is appropriate.

Assessment

This skill appears to be a local, dependency-free SQL formatter/linter and is internally consistent with that purpose. Before installing or running it, (1) review the full scripts/sql_format.py file (the prompt showed a truncated tail) to ensure there are no hidden network calls or file-system operations you don't expect; (2) run the script on non-sensitive sample files first or inside a sandbox if you are unsure of the source; and (3) prefer installing only skills from authors you trust or with a published homepage/repository if you plan to run them on sensitive data.

Format, minify, and lint SQL with zero dependencies.

Commands

All commands use scripts/sql_format.py.

Format SQL

python3 scripts/sql_format.py format --sql "SELECT id, name FROM users WHERE active = true"
python3 scripts/sql_format.py format --input query.sql
python3 scripts/sql_format.py format --input query.sql --output formatted.sql
python3 scripts/sql_format.py format --input query.sql --indent 4 --lowercase
echo "SELECT * FROM t" | python3 scripts/sql_format.py format --input -

Adds line breaks before major clauses (SELECT, FROM, WHERE, JOIN, ORDER BY, etc.), indents AND/OR/ON, and uppercases keywords by default.

Minify SQL

python3 scripts/sql_format.py minify --sql "SELECT  id,  name  FROM  users  -- comment"
python3 scripts/sql_format.py minify --input query.sql

Strips comments, collapses whitespace, removes unnecessary spaces around parentheses and commas.

Lint SQL

python3 scripts/sql_format.py lint --input query.sql
python3 scripts/sql_format.py lint --sql "SELECT * FROM users WHERE 1=1" --json

Checks for: SELECT *, multiple spaces, tabs, != vs <>, double commas, WHERE 1=1, long lines (>120 chars), trailing whitespace, missing semicolons, inconsistent keyword casing.

Supported SQL

Handles SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, WITH (CTEs), JOINs (all types), subqueries, string literals, double-quoted identifiers, single-line and multi-line comments.