Powerset Research
Access Powerset Research data
Powerset Research (https://research.powerset.co/) is a technical journal from Powerset (https://powerset.co/) where we analyze tech trends, publish analytics, and provide free tools for helping founders. This app allows anyone to access the data underlying Powerset Research via your AI.
MCP connector
- Server URL
https://research-mcp.powerset.dev/mcp/- Login
- None
- Protocol
- MCP 2025-11-25 · Interactive UI
- Instructions
Complete schema reference
Tables live under
github.main.*andgithub.analytics.*.github.<table>remains a DuckLake shortcut for main-schema tables. Prefer analytics tables for common search/profile/activity/comparison workflows; use raw main activity tables only when you need detail records.Schema: main
Repos (~404k rows)
Qualified name: github.main.repos repo_id BIGINT, repo_node_id VARCHAR, name_with_owner VARCHAR, stars_count INTEGER, fork_count INTEGER, created_at TIMESTAMP, pushed_at TIMESTAMP, updated_at TIMESTAMP
Repo_metadata (~405k rows)
Qualified name: github.main.repo_metadata repo_node_id VARCHAR, description VARCHAR, homepage VARCHAR, topics VARCHAR[], language VARCHAR, license_key VARCHAR, license_name VARCHAR, license_spdx_id VARCHAR, default_branch VARCHAR, size BIGINT, visibility VARCHAR, archived BOOLEAN, disabled BOOLEAN, is_fork BOOLEAN, is_template BOOLEAN, has_issues BOOLEAN, has_wiki BOOLEAN, has_pages BOOLEAN, has_discussions BOOLEAN, has_projects BOOLEAN, has_pull_requests BOOLEAN, has_downloads BOOLEAN, has_commit_comments BOOLEAN, watchers_count BIGINT, open_issues_count BIGINT, subscribers_count BIGINT, owner_type VARCHAR
Repo_scores (~404k rows)
Tools
Reads data7
Skills
None in the store listings or on the server