Skill Claude CodeCodex
Analyzes all SQL files in the Fabricks.Runtime repository, builds a dependency DAG, runs performance heuristics, and produces a Markdown report with ranked findings and improvement suggestions. Optionally fetches row counts and EXPLAIN COST plans from Databricks. Pass --fix to automatically create a branch and apply…
Skill Claude CodeCodex
Azure Entra ID SSO for FastAPI using cookie-based sessions (MSAL, /login → /callback → session). Trigger on: Azure AD login, Entra SSO, protect routes, RBAC, DEVMODE bypass, download links with auth. Covers App Registration, AuthMiddleware, role checks via Postgres, and cookie auth enabling native links.
Skill Claude CodeCodex
Use this skill whenever working with FastAPI — building APIs, adding routes, structuring projects, streaming responses, handling authentication, database access, or running the server. Triggers on: "fastapi", "build an API", "add an endpoint", "stream response", "SSE", "server-sent events", "async endpoint"…
Skill Claude CodeCodex
Use this skill whenever the user wants to bootstrap, scaffold, or initialize a new full-stack app with a Vite + React + TanStack + @bmsuisse/ui (shadcn/ui-based) frontend and a FastAPI + Postgres backend. Triggers on requests like "create a new app", "set up a project", "scaffold a full-stack app", "init a new…
Skill Claude CodeCodex
Use Inter as a UI typeface in data-dense B2B apps (dashboards, tables, cockpits) without triggering the "generic AI dashboard" look. Trigger when styling a new screen, reviewing an existing one for genericness, or when Inter is already the base face and the app needs to look more considered.
Skill Claude CodeCodex
Use this skill whenever the user is working with Kendo UI for Angular — including the Data Grid, TreeList, TreeView, DropDownList, AutoComplete, or any @progress/kendo-angular- package. Covers server-side paging/filtering/sorting, inline CRUD editing, row selection, custom cell templates, master-detail rows, grouping…
Skill Claude CodeCodex
KendoReact component library patterns and best practices for React developers. Trigger whenever the user works with KendoReact components, imports from @progress/kendo-react-, asks how to set up Grid, Form, DateInputs, Charts, or any KendoReact component, asks about theming or licensing, or asks to "use Kendo", "add a…
Skill Claude CodeCodex
Use this skill whenever the user is working with Kendo UI for Vue — including the Data Grid, DropDownList, ComboBox, AutoComplete, or any @progress/kendo-vue- package. Covers server-side paging/filtering/sorting, inline CRUD editing, row selection, custom cell templates, master-detail rows, grouping, Excel export, and…
Skill Claude CodeCodex
Kull.GenericBackend — an ASP.NET Core middleware (Kull-AG/kull-generic-backend, NuGet package Kull.GenericBackend) that exposes SQL Server stored procedures, views, and table-valued functions as REST endpoints from a backendconfig.json file, with Swagger/ OpenAPI generated automatically from spdescribefirstresultset…
Skill Claude CodeCodex
Build Python web UIs with NiceGUI — covering layout, widgets, data binding, routing, and the AgGrid data grid. Use this skill whenever the user mentions NiceGUI, wants to build a Python web app, dashboard, or internal tool, asks about ui.aggrid, ui.page, or any NiceGUI component. Triggers on: "nicegui", "ui.aggrid"…
Skill Claude CodeCodex
Browser automation and visual verification with Playwright in Python. Use this whenever the user wants to drive a browser from Python — taking screenshots of a running dev server or deployed page, scraping rendered content, automating clicks/forms, mocking network requests, or writing pytest browser tests. Also use…
Skill Claude CodeCodex
PostgreSQL coding standards for Python projects using psycopg (no ORM). Use this skill whenever the user is writing or reviewing code that queries PostgreSQL with psycopg, creates SQL files, maps query results to Python objects, or asks how to structure database access code. Triggers on things like "add a database…
Skill Claude CodeCodex
Set up and work with a local PostgreSQL test database in Docker for integration/e2e tests. Use this skill whenever the user wants to add, configure, troubleshoot, or run queries against a local test Postgres instance — even if they don't say "postgres" explicitly. Triggers on things like "set up a test database", "add…
Skill Claude CodeCodex
Set up code formatting and pre-commit hooks using prek (fast Rust-based alternative to pre-commit) with prek.toml config. Use whenever the user wants to configure prek, add formatters, set up pre-commit hooks, or enforce code style. Triggers on "set up prek", "add formatting", "configure formatters", "pre-commit…
Skill Claude CodeCodex
PostgreSQL-based async task queue for Python using Procrastinate. Use this skill whenever the user is working with Procrastinate — setting it up, defining tasks, deferring jobs, running workers, configuring retries, periodic tasks, or deploying to Azure (Web App or Container App). Also triggers on: "background jobs"…
Skill Claude CodeCodex
Python code optimizer and error fixer: analyzes a Python file or function, rewrites it for speed and quality one change at a time, validates with pytest, benchmarks with timeit, checks with ruff/ty, and measures complexity reduction. Also diagnoses broken Python code (SyntaxError, ImportError, TypeError…
Skill Claude CodeCodex
Detect and surgically fix AI writing patterns in English, German, French, or Italian text. Use this skill whenever the user asks to 'remove AI writing', 'fix AI tells', 'make this sound less like ChatGPT/Claude', 'avoid AI patterns', 'make this more human', 'de-slop my text', 'nettoyer le texte IA', 'KI-Schreibstil…
Skill Claude CodeCodex
Use whenever building a UI table, list view, or dashboard panel showing records with amounts, dates, or statuses (invoices, tickets, orders, tasks, leads, log entries, etc.) — in React/HTML/artifacts, TanStack Table column defs, or when writing/reviewing component code for one. Consult before rendering a "flat" table…
Skill Claude CodeCodex
Use this skill whenever the user wants to verify, revise, or improve a scientific essay, academic paper, or any written document. It checks citation consistency, verifies bibliography entries via CrossRef and Google Scholar/Semantic Scholar, and detects AI-generated writing patterns (slop). Trigger this skill whenever…
Skill Claude CodeCodex
Guide for running PySpark code locally against a remote Databricks cluster via Spark Connect (databricks-connect). Use this skill when asked how to set up Databricks Connect, connect to a cluster from a local machine, run notebooks or scripts locally with Spark semantics, understand the getsparksession() pattern…
Skill Claude CodeCodex
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle, Databricks). SQL style: sqlfmt lowercase, CTEs over subqueries, QUALIFY over rownumber subqueries, GROUP BY ALL…
Skill Claude CodeCodex
Comprehensive best practices for TanStack libraries in React applications — covering TanStack Query (React Query) data fetching, caching, and mutations; TanStack Router type-safe routing and search params; TanStack Query + Router integration patterns; TypeScript usage; and common pitfalls to avoid. Use this skill…
Skill Claude CodeCodex
Decide what kind of test to write and in what order for a backend feature: HTTP-level first, then Playwright e2e for the same flow. Use whenever adding or reviewing tests for an API endpoint or a user-facing flow, when the user asks "how should I test this", "add tests for X", "write an e2e test", or when a PR is…