Github Repo Explorer (Gloodata Extension)

A Python extension for Gloodata that lets you explore GitHub repositories stored in a local SQLite database. Designed for LLM-based interactions: query repo metadata, commits, and file trees through natural language, no UI needed.

🎥 Watch Youtube Demo

Setup

Prerequisites

• Python 3.12 or higher
• uv
• Gloodata

Check that you are in a recent version of uv:

uv self update

Project Setup

First you need to generate the githubrepo.db file using the scripts in tools/github-repo-to-sqlite.

Feel free to change the exported repository, here we are going to export the facebook/react repo:

cd tools/github-repo-to-sqlite
# get your token here https://github.com/settings/tokens
export GIHUB_TOKEN="YOUR TOKEN HERE"
bun run dumpRepo.js facebook react react-issues.json react-releases.json
bun run issuesToSqlite.js react-issues.json react-releases.json ../../githubrepo.db

GitHub docs: Managing your personal access tokens

Run

uv run src/main.py

Available environment variables and their defaults:

• EXTENSION_PORT: 9876
• EXTENSION_HOST: localhost
• EXTENSION_DB_PATH: ./githubrepo.db

For example, to change the port:

EXTENSION_PORT=6677 uv run src/main.py

Adding New Visualizations

1. Define new SQL queries in queries.sql
2. Create tool functions in src/toolbox.py using the @tb.tool decorator
3. Specify visualization types and parameters in the return dictionary

License

This project is open source and available under the MIT License.

Support

For questions, issues, or contributions, please open an issue on GitHub or contact the maintainers.