Free tools / Schema profile
Schema profile prompt for credit-risk tables
Every other prompt works better when the AI knows your tables. Fill this in once and paste the result at the top of any prompt. It is free, needs no sign-up, and works from table and column names alone.
What you enter
You type names only: table and column names, never customer data.
- Table name
- One row is...
- Key column(s)
- Columns (one per line: name, type, meaning)
How to use it
- Enter the table that holds most loan facts first, then repeat for the payment, schedule and bureau tables.
- Paste the prompt into your AI tool and answer its questions.
- Save the final schema card in a note. Paste it at the top of every later prompt.
Checks to run on the answer
AI can write SQL that looks right and is wrong. Run these checks before you trust the result.
- Every column name matches your database exactly, including case.
- The grain is stated. A table with several rows per loan says so.
- Join keys between tables are written down.
- No customer names, numbers or sample values appear in the card.
Open the tool
You get the ready prompt, the checks above, what healthy and warning results look like, and how to present the result to an approver.
Open the free toolsRelated guides
Delinquency buckets: 1-30, 31-60, 61-90 and 90+ explained
What delinquency buckets are, how DPD maps to them, how they link to RBI's SMA categories and Ind AS 109 stages, and how to report them.
Using AIHow to check AI-written credit-risk SQL before you trust it
AI tools write SQL that runs but may be wrong. Ten checks to run on any credit-risk query: row counts, duplicates, DPD edges, bucket totals and a hand trace.