Free tools / Data dictionary
Data dictionary prompt for loan tables
Turns your table list into a plain-English data dictionary. The AI works from names only, so it marks every guess and lists what to ask your data owner. 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.
- Your tables and columns
- Type of lending
- Who will read it
How to use it
- Check the table list. Remove tables you do not need.
- Run the prompt in your AI tool.
- Send the questions for the data owner to your data team. Fix every Guess row with their answers.
- Keep the final dictionary and share it with the team.
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 in your list appears in the dictionary.
- No column has an invented value range or business rule.
- Every Guess row was confirmed with the data owner.
- Each date column says which event it belongs to: due, payment or disbursal.
- Each amount column says whether it includes interest, fees or tax.
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
How 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.
Using AIUsing AI for credit-risk work without sharing customer data
You can get useful credit-risk SQL and analysis from an AI tool by sharing only table and column names. How the method works and what to keep out of the chat.