rill
Data analysis using Rill's metrics layer via Model Context Protocol
Open source Open in the app JSON README (API)
About
Data analysis using Rill's metrics layer via Model Context Protocol
Details
- Kind
- Plugins
- Topic
- AI, RAG & memory
- Publisher
- rilldata
- Origin
- gemini
- Category
- ferramentas
- Version
- 0.1.1
- Stars
- 5
- Last push
- 2025-12-16T20:17:14Z
- Repository state
- ativo
- License
- Apache-2.0
- Added
- 2026-08-30 14:13:39
- Updated
- 2026-08-30 14:13:39
- Origin id
rilldata/rill-gemini-extension
README
# Rill Gemini Extension Data analysis using Rill's metrics layer via Model Context Protocol for **Google Gemini CLI**. This extension enables Google's Gemini AI assistant to query and analyze your Rill data directly through natural language conversations. Using the Google Gemini CLI and the Model Context Protocol (MCP), you can explore metrics, identify trends, and generate insights without writing queries manually. ## Prerequisites - A Rill project or cloud account — get started [here](https://docs.rilldata.com/) - [Rill CLI](https://docs.rilldata.com/install) - [Google Gemini CLI](https://github.com/google-gemini/gemini-cli) ## Installation Install the extension with the Google Gemini CLI: ```bash gemini extensions install https://github.com/rilldata/rill-gemini-extension ``` You will be prompted to provide your Rill organization and project. ```bash # You should see 'rill' listed among installed extensions gemini extensions list ``` Rill Supports MCP Oauth authentication. ```bash /mcp auth rill ``` ## Usage Once installed and configured, you can start using the Rill extension in your Google Gemini CLI conversations. Simply ask questions about your Rill metrics views, and the extension will generate insights based on your data. ```shell gemini "Using Rill, tell me about any trends you see in the Ads Bids dataview" ``` > Example output: [Analysis](docs/sample.md) ```shell gemini "Tell me about the top publishers by ad spend in the Ads Bids dataview" ``` ```shell Based on my initial analysis, I'll focus on the top named publishers: KrushMedia, Sinclair Broadcasting, and Taboola. Here's a breakdown of the top 10 publishers by ad spend: ┌──────────────────────────────────────┬───────────────────┬─────────────┐ │ Publisher │ Advertising Spend │ Impressions │ ├──────────────────────────────────────┼───────────────────┼─────────────┤ │ KrushMedia │ $755,058.21 │ 50,219 │ │ Sinclair Broadcasting - Bally Sports │ $419,923.62 │ 30,002 │ │ Taboola │ $408,628.51 │ 81,782 │ │ PubWise │ $202,980.07 │ 26,089 │ │ Disney │ $48,075.66 │ 4,055 │ │ Connatix │ $40,485.67 │ 7,090 │ │ Spot.IM │ $38,171.29 │ 6,576 │ │ Pluto TV │ $36,175.64 │ 4,396 │ │ fubo.TV New │ $23,563.37 │ 1,641 │ └──────────────────────────────────────┴───────────────────┴─────────────┘ ``` > Examples used: [Examples](https://github.com/rilldata/rill?tab=readme-ov-file#production-examples) ### Custom Slash Commands This extension includes custom slash commands for common Rill analysis workflows. Use these commands in your Google Gemini CLI conversations to streamline your data exploration: #### Available Commands - **`/rill:metrics`** - List all available metrics views in your Rill project with descriptions - **`/rill:explore`** - Start a comprehensive OODA loop analysis for a specific metrics view - **`/rill:trends`** - Analyze time-based trends with automatic granularity selection - **`/rill:compare`** - Compare metrics across dimensions or time periods - **`/rill:timerange`** - Check the available time range and data freshness for a metrics view ## Uninstallation ```bash gemini extensions uninstall rill ``` ## Troubleshooting ### What the installer prompts mean When running the installer you may be asked for Organization, Project, and a user/service token — these are prompts to help populate the extension's configuration. The values will be saved to a `.env` file in the extension’s directory (e.g., `~/.gemini/extensions/rill/.env`). - `Keychain not available` — this is informational, not fatal. It indicates the installer couldn't store credentials in the OS keychain and will fall back to file-based storage. ### Connection Issues If you can't connect to your Rill project: - Verify your `.env` file or inputs contain valid credentials - Confirm your user/service token has the necessary permissions - Check that your organization and project names match your Rill Cloud URL ## Development ### Local Development To test changes locally: 1. Make your changes to the extension files 2. Install the extension from your local development directory: ```bash npm run link ``` 3. Test the extension with the Google Gemini CLI, then unlink when done: ```bash npm run unlink ``` ### Releasing This extension is distributed through [GitHub Releases](https://docs.github.com/en/repositories/releasing-projects-on-github/about-releases)