CleenUI · AI agent skills

Schema & Procs skill

Authors T-SQL tables + stored procedures following CleenUI's schema conventions (sibling *Language tables, audit history, soft-delete, row-level access).

The Schema & Procs skill is the AzureSQL counterpart. When a developer says "add a Notes table for tasks" or "add a sp_NotesGetByFilter procedure," the skill produces hand-tuned T-SQL that matches the 300+ tables and 700+ stored procs already in CleenUI.

It knows the schema patterns by heart: sibling <Entity>Language tables for translation, History tables for versioning, IsDeleted columns for soft-delete, AccountID columns for row-level access. Stored procedures follow the sp_AdminEntitySave, sp_GetEntityByFilter naming + parameter conventions. Migrations are scripted T-SQL files checked into the repo — no ORM-generated surprises.

What the skill does

  • Generate a table definition with the standard columns (audit, soft-delete, row-level access, translation siblings).
  • Author stored procedures following the project naming conventions (sp_<Module><Entity><Verb>).
  • Embed row-level account-scoping in every read + write proc.
  • Produce a numbered migration file checked into the migrations folder.
  • Update the translation registry so new translatable columns get picked up automatically.
⚡ Already in an AI editor?

Set up CleenUI in your tool.

To use the Schema & Procs skill in practice, register CleenUI in your AI editor — five-minute setup per tool, guides below.

Claude CodeCursorWindsurfGitHub CopilotClineAider+6All 12 guides