Explorations: a chat UI for real-time analytics

Explorations is a feature within Tinybird designed to streamline data analysis by providing a notebook-style interface for exploring data through tables and charts, complemented by an AI chat interface that translates natural language questions into SQL queries. This tool emerged from the need to efficiently understand data shapes and query them without the tedium of manual SQL coding, offering a conversational analytics approach and interactive visualizations. By leveraging a custom system prompt for a language model, Explorations integrates contextual data, such as schemas and data samples, to facilitate intuitive querying and analysis, akin to the MCP server but with added UI integration. The feature has been in beta and is now publicly available, enabling users to explore data effectively by simply asking questions and receiving immediate SQL-based responses, as demonstrated through code contribution analysis with data from GitLab.