# join-monster/join-monster

A GraphQL to SQL query execution layer for query planning and batch data fetching.

Repository: https://github.com/join-monster/join-monster
Canonical: https://ross.abutalabs.com/products/join-monster
Homepage: http://join-monster.readthedocs.io/en/latest/
Language: JavaScript
License: MIT
License Family: permissive
Topics: graphql, graphql-js, sql, nodejs, sql-query, join
Last push: 2025-08-06T00:23:00+00:00

## Health v2 (maintenance only)
Score: 39/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 35, release rhythm 8, longevity 100
- inputs: {"age_days": 3639, "days_push": 393, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2701, forks 227 (observed 2026-08-28T04:07:11.406861+00:00)

## What it is
Join Monster is a JavaScript library that acts as a query execution layer between GraphQL and SQL databases, translating GraphQL queries into efficient SQL joins. It enables query planning and batch data fetching to avoid the N+1 problem in GraphQL APIs.

## Use cases
- avoid N+1 queries in a GraphQL API
- translate GraphQL queries into SQL joins
- batch fetch nested relational data for GraphQL resolvers
- build a GraphQL server backed by a SQL database
- implement Relay-style cursor pagination over SQL
- optimize GraphQL query planning for relational databases

## When to choose
- your GraphQL API reads from a relational SQL database with deeply nested relations
- you want to eliminate N+1 fetches with a single joined SQL query
- you need Relay cursor pagination mapped onto SQL

## When to avoid
- your data comes from non-SQL sources like REST APIs or NoSQL stores
- you prefer an ORM-first approach with simple per-field resolvers
- your schema is simple enough that a data loader pattern suffices

## Facets
- artifact type: library
- maturity: active
- function: graphql, database, orm, middleware
- domain: web-development, backend, databases, apis
- platform: -
- tags: graphql-to-sql, query-planning, batch-data-fetching, sql-query-generation, dataloader-alternative, nodejs, javascript

## Member repositories
- join-monster/join-monster (main) score 39

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:11.406861+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:15:58.639590+00:00, confidence not recorded.
  - readme: https://github.com/join-monster/join-monster (fetched 2026-08-28T04:07:11.406861+00:00, sha c89384509088)
- Data as of 2026-08-30T08:39:29.467469+00:00.