All Medical AI: Natural-Language SQL Data Analyst & Clinic Intelligence OS
An AI data analyst and operational dashboard for dental and medical operations that translates natural-language business questions into verified SQL queries and visual reports.
PythonAI SQL AnalystHealthcareAnalytics
Context
Healthcare and medical-supply operators sit on rich operational databases, but answering ad-hoc margin or utilization questions usually requires waiting on a developer to write SQL.
Scope I disclose publicly
- Schema-aware text-to-SQL analyst that turns plain-language questions into read-only SQL queries and chart visualizations.
- Operational KPI views covering clinic utilization, inventory movement, and revenue breakdowns.
- Strict query sandboxing ensuring generated queries can never mutate or drop underlying tables.
Decisions and trade-offs
- Enforcing read-only database credentials and AST validation on every AI-generated SQL statement.
- Showing the underlying query and result rows alongside every AI summary so managers can verify numbers immediately.
- The trade-off: schema-grounded SQL execution refuses vague unanswerable prompts instead of guessing.
A live deployment is accessible at mbardouni.dev/allmedical/.
Check the public sourceDisclosure: The public demo runs on synthetic sample data.