Live demo Ask my weather warehouse a question in plain English MCP · LangChain · Gemini · text-to-SQL — live app, opens in a new tab

Data visualizations

These are my latest, fully-interactive data visualizations!

  • All visualizations are 100% code based and customizable.
  • Languages used to produce include: Python, SQL, Bash/Command Line, HTML, CSS & JS.
  • The cleaned & transformed data is hosted within PostgreSQL 16 databases — self-managed on an AWS EC2 instance.
  • The automated data pipelines created to generate, ingest, transform and serve the data utilize AWS tools including: S3 buckets, Lambda functions & layers, and EventBridge schedules.
  • Every app above is served from that same instance behind nginx, over HTTP/2 and TLS, each as its own systemd service.
  • Prefer to ask rather than click? The same warehouse is queryable in plain English through the SQL Explorer, which writes the PostgreSQL for you and shows you the query it ran.

Back to home