Ponytail SQL Objects — Security skill for Claude Code

How to use this skill

This skill makes Claude write SQL Server objects the way this project requires — the audit columns, the soft delete, the naming, the header blocks, the descriptions — without you having to restate the rules each time. It also installs and checks the change logging that records who altered which database object.

You do not run this skill. You just ask for what you want, and it applies.

---

1. Install it (once)

The folder must be named after the skill, and it goes in one of two places.

**For this project only:**

\.claude\skills\ponytail-sql-objects\

**For every project on this machine:**

C:\Users\\.claude\skills\ponytail-sql-objects\

Copy this whole folder there and rename the copy to `ponytail-sql-objects` — `SKILL.md`, `templates\`, `scripts\` and `references\` must all sit inside it. Then restart Claude Code. Type `/skills` to confirm `ponytail-sql-objects` is listed.

That is the entire installation. Nothing to configure, no dependencies.

---

2. Use it (just ask)

Ask in plain language. The skill loads by itself when the request touches SQL objects.

Say something like	You get
"Add a Permit table to dbo"	A guarded CREATE TABLE with all 7 audit columns, DF_dbo_Permit_* constraint names, a filtered unique index, an AFTER UPDATE trigger that maintains the audit columns, and a description on the table and every column
"Add a PermitStatus column to dbo.Permit"	A separate guarded ALTER TABLE ... ADD block — it will not edit the original CREATE TABLE
"Write a view over dbo.Permit"	A CREATE OR ALTER VIEW with the header block and WHERE IsDeleted = 0
"Write a procedure that merges the permit batch"	A procedure with the header block, TRY/CATCH, the logs.ExecutionLog instrumentation, and a bare ;THROW;
"Does this database record its schema changes?"	The read-only check script, and what to do about anything missing
"Set u