MTES-MCT

Configure this repo for the engineering skills — set up its issue tracker, triage label vocabulary, and domain doc layout. Run once before first use of the other engineering skills.

Move issues through a state machine of triage roles — categorise, reproduce, grill if needed, and write agent-ready briefs.

Publish a French-language LOVAC import report to Notion after all subcommands and snapshots are complete. Reads snapshot-*-pre.json / snapshot-*-post.json and *.report.json files from the current directory.

ZLV production deploy summary workflow. Use when preparing a production release (mise en production): writing the GitHub deploy PR summary, finding Notion tickets, and creating the corresponding Notion release note page.

Use when adding or modifying a Dagster asset, job, schedule, or resource in `analytics/dagster/`. Enforces ZLV asset key conventions, the CustomizedDagsterDbtTranslator contract, retry/resource wiring, and a validate→materialize verification loop. Trigger phrases: "add a dagster asset", "new ingest pipeline", "schedule a refresh", "create a multi_asset".

Use when adding or modifying a dbt model in `analytics/dbt/`. Enforces ZLV layer/naming rules, ref()/source() discipline, schema.yml docs+tests, and a compile→run→test verification loop. Trigger phrases: "add a dbt model", "modify staging/intermediate/marts", "create stg_/int_/marts_…".

Use to onboard a new external dataset (data.gouv.fr, INSEE, DGFIP, DGALN, CEREMA, URSSAF, S3 Cellar) into the ZLV warehouse end-to-end: register the source, validate, materialize via Dagster, and expose to dbt. Trigger phrases: "add a new external source", "ingest a new dataset", "onboard data.gouv.fr file", "register a CEREMA file".

Use to investigate the ZLV data warehouse on MotherDuck (`dwh`) — list tables, inspect columns, run scoped queries, profile distributions, validate KPIs. Trigger phrases: "explore data", "check the warehouse", "how many rows", "what's the distribution of …".

Extracts methods from the monolithic RoseauGateway/RoseauRepository into a dedicated gateway/repository pair within the same folder. Use this when moving domain-specific methods out of roseau.gateway into their own gateway.

Creates a full-stack paginated table page with filters, sorting, and detail view — from SQL to React — using MasaProvider.

Creates new functionalities that fetch reference data via MasaProvider instead of directly using LanceleauGateway or RoseauGateway.

Creates unit and e2e tests for NestJS applications using Jest and Supertest. Includes patterns for testing services, controllers, guards, and e2e tests with testcontainers.

Creates a typed API endpoint across shared route definition, NestJS controller, frontend service, and Query hook.

Creates unit tests for React frontend components using Vitest and React Testing Library, following accessibility-first best practices.

Develops, styles, and tests DSFR-compliant React 19 components.

Collecte auprès de l'usager toutes les informations et fichiers nécessaires pour compléter un dossier DossierFacile individuel (ALONE, sans garant). Utilise ce skill avant d'appeler l'API d'écriture, pour savoir quoi demander à l'usager et quels documents récupérer.

Complète intégralement un dossier DossierFacile à partir d'un prompt en langage naturel. Orchestre l'authentification, la collecte d'informations, la lecture du profil existant et le remplissage via l'API. Utilise ce skill quand un usager demande à remplir, compléter ou soumettre son dossier DossierFacile.

Complète un dossier DossierFacile via l'API d'écriture (routes POST/DELETE). Couvre les noms, le type de candidature, les 5 catégories de documents (identité, résidence, profession, finances, impôts) et la déclaration sur l'honneur. Utilise ce skill pour savoir quelle route appeler, avec quel payload, lors du remplissage d'un dossier individuel (ALONE, sans garant).

Authentifie un usager sur DossierFacile via Keycloak OIDC (flux authorization_code + PKCE) et obtient un token d'accès JWT valide pour l'API (preprod ou production). Utilise ce skill quand tu dois appeler l'API DossierFacile au nom d'un usager, obtenir ou rafraîchir un token, ou configurer le client Keycloak agent.

Lit et interprète le profil d'un locataire DossierFacile via GET /api/tenant/profile. Utilise ce skill pour connaître l'état d'avancement d'un dossier, identifier les sections manquantes ou refusées, et déterminer ce qu'il reste à compléter.

Next.js App Router expert guidance. Use when building, debugging, or architecting Next.js applications — routing, Server Components, Server Actions, Cache Components, layouts, middleware/proxy, data fetching, rendering strategies, and deployment on Vercel.

Next.js best practices - file conventions, RSC boundaries, data patterns, async APIs, metadata, error handling, route handlers, image/font optimization, bundling

Assistant pour écrire et valider des requêtes SQL sur dossierfacile

Vérification post-implémentation (lint, typecheck, tests, build)