← Back to Skills Marketplace
Sqlformat
by
bytesagain3
· GitHub ↗
· v2.0.0
· MIT-0
234
Downloads
0
Stars
1
Active Installs
1
Versions
Install in OpenClaw
/install sqlformat
Description
Format, lint, and pretty-print SQL with dialect conversion. Use when checking style, validating syntax, formatting queries, generating clean SQL.
Usage Guidance
This skill appears to be a straightforward local SQL formatting/linting CLI that stores all inputs in plain-text log files. Before installing or running: 1) Inspect the full script (the provided script snippet appears truncated in the review copy) to confirm there are no hidden network calls or unexpected commands. 2) Avoid passing any sensitive data (passwords, connection strings, or PII) to the tool; anything you pass can be logged. 3) If you need to use it with sensitive queries, set SQLFORMAT_DIR to a secure directory with restrictive permissions (chmod 700) or use a temporary/sandboxed account. 4) Periodically review and securely delete logs (or add redaction) if they contain secrets. 5) Because the tool stores data locally, there is no automatic exfiltration observed in the visible code, but verify the remainder of the script before trusting it in sensitive environments.
Capability Analysis
Type: OpenClaw Skill
Name: sqlformat
Version: 2.0.0
The skill is deceptive; while SKILL.md describes a comprehensive SQL formatting, linting, and dialect conversion toolkit, the implementation in scripts/script.sh only appends input queries to local log files in ~/.local/share/sqlformat/ without performing any actual SQL processing. This discrepancy between the stated purpose ('Format and pretty-print', 'Validate SQL syntax') and the actual behavior (simple logging) is suspicious because it could mislead an AI agent into reporting that SQL has been successfully validated or transformed when it has only been recorded, potentially leading to the propagation of unverified or malformed code.
Capability Assessment
Purpose & Capability
Name/description match the implementation: a bash-based CLI that formats/lints/records SQL-related entries. Required tools and declared capabilities align with a local devtool.
Instruction Scope
SKILL.md and script instruct the agent to accept SQL input and record timestamped entries to local log files (~/.local/share/sqlformat by default). This is within scope for a logger/formatter, but it means any SQL you pass (including connection strings, queries with literals, or credentials) will be stored in plain text. The SKILL.md does not explicitly warn about logging sensitive data.
Install Mechanism
No install spec or downloads are present; the skill is instruction + a local bash script. No external package installs or remote downloads are used.
Credentials
No credentials or secret environment variables are required. One optional env var (SQLFORMAT_DIR) controls storage location, which is reasonable. However, the skill's logging behavior creates a data persistence risk for any sensitive SQL passed to it.
Persistence & Privilege
The skill creates and writes only its own data directory under the user's home (~/.local/share/sqlformat by default). always:false and no system-wide configuration changes are requested.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install sqlformat - After installation, invoke the skill by name or use
/sqlformat - Provide required inputs per the skill's parameter spec and get structured output
Version History
v2.0.0
Domain-specific upgrade
Metadata
Frequently Asked Questions
What is Sqlformat?
Format, lint, and pretty-print SQL with dialect conversion. Use when checking style, validating syntax, formatting queries, generating clean SQL. It is an AI Agent Skill for Claude Code / OpenClaw, with 234 downloads so far.
How do I install Sqlformat?
Run "/install sqlformat" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Sqlformat free?
Yes, Sqlformat is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Sqlformat support?
Sqlformat is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Sqlformat?
It is built and maintained by bytesagain3 (@bytesagain3); the current version is v2.0.0.
More Skills