Can an AI SQL Agent build a weighted scoring system from scratch?
- Amar Harolikar
- 3 days ago
- 2 min read
Try it yourself. I’m sharing RBI data + instructions. Run it on DATS-4 SQL Agent and get a full analysis as multi-page PDF report.
𝗔 𝗰𝗼𝗺𝗺𝗼𝗻 𝗮𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝘁𝗮𝘀𝗸 → subjective segmentation and ranking.
𝗧𝗵𝗲 𝗗𝗮𝘁𝗮
Reserve Bank of India, Monthly ATM/POS/Cards Stats, July 2025.
RBI publishes this as Excel. If you need CSV: use my Excel-to-CSV RBICC converter tool:
𝗧𝗵𝗲 𝗧𝗮𝘀𝗸
▪️ Create a weighted composite score to rank Indian banks on credit cards.
▪️ Derive ratios and new variables to support the ranking.
--------------------------------
𝗛𝗼𝘄 𝘁𝗼 𝗥𝘂𝗻 𝗜𝘁
𝟭. 𝗚𝗼 𝘁𝗼 𝗗𝗔𝗧𝗦-𝟰 → app.tigzig.com → Database AI & SQL Apps → DATS-4.
• Click Try Sample → Select dataset → Use Temporary Database. Zero setup.
𝟮. 𝗚𝗶𝘃𝗲 𝘁𝗵𝗲 𝗜𝗻𝘀𝘁𝗿𝘂𝗰𝘁𝗶𝗼𝗻𝘀 → Copy the provided prompt.
• The ask: rank banks, design a scoring system, derive new variables, generate charts, and explain the process.
𝟯. 𝗥𝗲𝘃𝗶𝗲𝘄 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 → Agent shares full plan, SQL, debugging steps, and reasoning.
𝟰. 𝗜𝘁𝗲𝗿𝗮𝘁𝗲 → Adjust weights or logic. Rerun to see updated results.
𝟱. 𝗚𝗲𝘁 𝗥𝗲𝗽𝗼𝗿𝘁 → Ask for PDF output in A4 width (Supports text only for now)
-----------------------------------------
𝗥𝗲𝗮𝗹𝗶𝘁𝘆 𝗖𝗵𝗲𝗰𝗸
Live work isn't click-click and out pops a PDF. This is the final 5%. In live projects, the 95% is:
𝟭. 𝗗𝗮𝘁𝗮 𝗠𝗮𝗿𝘁𝘀 & 𝗖𝗹𝗲𝗮𝗻𝗶𝗻𝗴 → recons, data cleaning, data formats, joining vars
𝟮. 𝗔𝗴𝗲𝗻𝘁 𝗦𝗲𝘁𝘂𝗽→ agents misfire, over-query, miss variables. Getting reliable behavior is iterative and sometimes frustrating.
𝟯. 𝗜𝗻𝗳𝗿𝗮 → UI, backends, monitoring, auth, access controls, costing,
𝟰. 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆 → The public facing app routes all API calls via my backend. Use it for sandbox testing only. For live deploy: run on your own VPN / harden auth.
𝗗𝗮𝘁𝗮 𝗦𝗶𝘇𝗲
This example uses a 64-row aggregated file. The reasoning process is the same whether 64 rows or 64M. For larger workloads, see my previous cricket data post, and earlier posts on agents running analytics across multiple tables with millions of records.
-----------------------------
𝗗𝗔𝗧𝗦-𝟰 𝗶𝘀 𝗳𝘂𝗹𝗹𝘆 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝗮𝗹 𝗮𝗻𝗱 𝗢𝗽𝗲𝗻 𝗦𝗼𝘂𝗿𝗰𝗲
𝗦𝗼𝘂𝗿𝗰𝗲 𝗖𝗼𝗱𝗲 → Docs → Build It (on app site)
𝗔𝗜 𝗦𝗤𝗟 𝗔𝗽𝗽𝘀 → voice-connected, ChatGPT-to-database, rapid deploy options
𝗦𝗤𝗟 𝗔𝗴𝗲𝗻𝘁 𝗙𝗶𝗲𝗹𝗱 𝗚𝘂𝗶𝗱𝗲 → 49 pages of practical setup guidance. https://app.tigzig.com/files/DATS_4_DATABASE_AI_SUITE.pdf
𝗖𝗼𝘀𝘁𝗶𝗻𝗴 𝗚𝘂𝗶𝗱𝗲 → Updated Sep 2025, LLM cost–quality matrix & best practices. https://app.tigzig.com/files/DATS4_COSTING_UPDATE_SEP2025_QWEN.pdf
