Skip to content
CAI
Software that uses CAICheck a score

typelevel/grackle

61.9

Adequate · 7 November 2026

19.1k

lines of production code

Scala

primary language

4

measurements over time

CAI band scale
CAI trend line
CAI lens gauges

What this system is

Features

Add H2 database backend for Doobie queries

This change introduces a new H2 backend for the Grackle Doobie integration, allowing users to run queries against H2 databases. The implementation in \DoobieH2Mapping.scala\ adapts SQL generation for H2's specific dialect, handling features like \OFFSET\/\FETCH\ syntax, \ILIKE\ for case-insensitive matching, and \DISTINCT ON\, while accounting for H2's lack of \LATERAL\ joins and its default NULL ordering behavior. The module includes a test suite (\DoobieH2DatabaseSuite\ and \DoobieH2Suites\) that validates these mappings against shared SQL test cases, ensuring compatibility for features such as array joins, JSON handling, and mutations.

modules/doobie-h2 · high confidence

Add MySQL backend support via Doobie

This change introduces a new MySQL backend for the Grackle Doobie integration, enabling users to query MySQL 8.0.14+ databases. The implementation provides a \DoobieMySqlMapping\ that handles MySQL-specific SQL dialect nuances, including case-insensitive LIKE operations, LIMIT/OFFSET syntax, NULL ordering, and JSON/CAST type mappings. It also includes the necessary test infrastructure, such as a Docker entrypoint script to configure character sets and a comprehensive suite of database tests to verify compatibility.

modules/doobie-mysql · high confidence

Add SQLite backend for Grackle Doobie

A new SQLite backend (\grackle-doobie-sqlite\) is now available, allowing users to run Grackle queries against SQLite databases. This implementation bridges SQLite-specific SQL dialect differences—such as the lack of LATERAL joins, parenthesized UNION branches, and native date/time types—by adapting the shared query builder's rendering hooks. It includes a test suite that validates core functionality, including null ordering, nullable parents, and error keys, ensuring compatibility with existing Grackle features on this platform.

modules/doobie-sqlite · high confidence

Added DB-backed demo with PostgreSQL support

The demo application now includes a database-backed example that connects to a PostgreSQL database using Doobie. This change introduces new files in the demo world package to manage database connectivity and GraphQL schema mapping, allowing users to interact with a live database schema (Country, City, Language) via GraphQL queries instead of in-memory data.

demo/src/main/scala/demo/world · high confidence

Added GraphQL schema parsing benchmark using the GitHub schema

A new JMH benchmark (ParserBenchmark) has been added to the benchmarks module to measure the performance of the GraphQL schema parser. The benchmark loads the full GitHub GraphQL schema (github.graphql) from resources and parses it, allowing users to track parsing throughput over time.

benchmarks · high confidence

Added Oracle database backend support

Users can now query Oracle databases using the Grackle Doobie integration. This new backend implements Oracle-specific SQL syntax, including 'FETCH FIRST ... ROWS ONLY' for limits, 'OFFSET ... ROWS' for pagination, and 'COLLATE "binary"' for string comparisons. It also handles Oracle-specific type conversions (e.g., mapping VARCHAR to CHAR) and case-insensitive LIKE operations via UPPER() functions.

modules/doobie-oracle/src/main · high confidence

Added SQL Server backend for Grackle

Introduced a new SQL Server (MSSQL) backend via the \DoobieMSSqlMapping\ module, enabling Grackle to generate queries compatible with Microsoft SQL Server. This implementation handles MSSQL-specific syntax requirements, including the mandatory pairing of \ORDER BY\ with \OFFSET\/\FETCH\ clauses, specific type casting for null values (e.g., mapping \BOOLEAN\ to \BIT\), and custom logic for sorting NULLs, which SQL Server handles differently than other databases.

modules/doobie-mssql/src/main · high confidence

Added Scala 2 and Scala 3 specific generic mapping implementations

The generic mapping module now includes version-specific implementations for Scala 2 and Scala 3. The Scala 2 version (\genericmapping2.scala\) utilizes Shapeless 2 for deriving cursor builders from product and coproduct types, while the Scala 3 version (\genericmapping3.scala\) uses Shapeless 3's \K0\ type classes for the same purpose. Both implementations provide \MkObjectCursorBuilder\ and \MkInterfaceCursorBuilder\ traits that enable automatic mapping of case classes and sealed traits to GraphQL types, supporting field renaming and transformation.

modules/generic/src/main/scala-2 · high confidence

Added Scala 3 version-specific syntax for schema and document literals

The core module now includes a Scala 3-specific implementation of the \VersionSpecificSyntax\ trait in \syntax3.scala\. This adds \schema\ and \doc\ extension methods to \StringContext\, allowing users to define GraphQL schemas and documents using compile-time validated string literals. The implementation leverages the \literally\ library and Scala 3 macros to parse and validate these strings at compile time, providing immediate feedback on invalid syntax.

modules/core/src/main/scala-3 · high confidence

Added benchmarking infrastructure for the profile module

A new \Bench.scala\ file has been added to the \profile\ module, providing a concrete benchmarking setup using Doobie and PostgreSQL. This file defines a \WorldPostgresSchema\ and \WorldMapping\ that map GraphQL queries (such as \cities\, \country\, and \countries\) to SQL table definitions and join logic, enabling performance profiling of the query compiler and database interaction layer.

profile · high confidence

Added database-specific query scripts for SQL Server and Oracle

New shell scripts have been added to support querying SQL Server and Oracle databases alongside the existing PostgreSQL script. The mssql-query.sh script executes queries using sqlcmd with hardcoded credentials, while oracle-query.sh uses sqlplus with rlwrap for interactive sessions. An oracle-opts.sql file was also added to configure SQL\*Plus output formatting.

scripts · high confidence

Added demo resources for GraphQL Playground and database schema

The demo module now includes a GraphQL Playground interface (assets/playground.html) for interactive API exploration, a PostgreSQL database schema (db/world.sql) containing sample city, country, and country language data, and a logging configuration (logback.xml) that sets the root level to INFO and suppresses Flyway migration logs.

demo/src/main/resources · high confidence

CursorBuilder now supports contramap for type transformation

The CursorBuilder trait in the generic module now includes a contramap method, allowing users to transform the input type of a cursor builder while preserving its type information. This enables more flexible cursor construction by mapping from a different source type to the expected type T.

modules/generic/src/main/scala · high confidence

Initial release of Grackle GraphQL query engine

This change introduces the Grackle library, a Scala-based GraphQL query engine. It provides a complete implementation including a parser for GraphQL SDL and query documents, a query compiler that translates queries into an algebraic intermediate representation, and a mapping system that bridges GraphQL schemas to underlying data sources. The release includes core modules for AST, parsing, compilation, and cursor-based data traversal, along with a Circe module for JSON handling and demo applications (Star Wars in-memory and World with PostgreSQL) to illustrate usage.

repository · high confidence

Initial release of Grackle core library

This change introduces the initial version of the Grackle GraphQL library for Scala, establishing the core runtime and developer tooling. It adds the \ComposedMapping\ abstraction for handling field mappings, a complete GraphQL introspection implementation (including schema types, directives, and encoders), and a \QueryMinimizer\ for compacting GraphQL documents. The release also includes JSON extraction utilities, syntax helpers for result handling, and defines the core package structure under \grackle\, while removing legacy placeholder files.

modules/core/src/main/scala · high confidence

MariaDB backend support added

A new MariaDB backend has been added to the Grackle Doobie integration, enabling users to query MariaDB databases using the same GraphQL mapping interface as other supported databases. The implementation includes a dialect-specific mapping layer that handles MariaDB's unique SQL syntax, such as its lack of LATERAL joins, specific LIMIT/OFFSET behavior, and case-insensitive LIKE defaults. A comprehensive test suite is included to verify compatibility across various SQL features including joins, mutations, JSON handling, and complex filtering.

modules/doobie-mariadb · high confidence

New SQL core abstractions and test mappings for non-Postgres backends

The sql-core module introduces a new SqlModule trait that abstracts the underlying database layer, defining types for SQL fragments, encoders, codecs, and fetch operations to support non-Postgres backends. It also adds a Like predicate for pattern matching strings and a SqlMonitor trait for tracking query execution. To validate these changes, a comprehensive suite of test mappings and suites has been added, covering array joins, coalesced queries, composed worlds with currency data, composite keys, cursor-based JSON fields, and various embedding scenarios.

modules/sql-core · high confidence

New build tools for multi-dialect test data generation

The build now includes a new Scala module in the \project/\ directory that generates SQL initialization scripts for test containers across six database dialects (Postgres, Oracle, SQL Server, SQLite, H2, and MySQL). This tool reads shared CSV data and dialect-specific schema files to produce correct INSERT statements, handling dialect-specific differences in arrays, timestamps, and booleans. Additionally, the build infrastructure has been updated to SBT 1.13.0 and migrated to the sbt-typelevel plugin ecosystem, replacing the previous sbt-gsp and sbt-ci-release plugins.

project · high confidence

New demo application with Star Wars and World GraphQL examples

The demo module now includes a runnable application that serves two GraphQL endpoints: a Star Wars example and a World example. The server is built using http4s with Ember, exposing routes for both examples under the /starwars and /world prefixes, and includes error handling and logging for debugging.

demo/src/main/scala/demo · high confidence

Postgres-specific Doobie mapping and test infrastructure

The \modules/doobie-pg\ module now provides the concrete Postgres implementation for the Doobie database layer, including \DoobiePgMapping\ which wires up the Postgres transactor and monitor, and a comprehensive suite of integration tests (\DoobiePgSuites\) covering features like array joins, JSONB, mutations, and composite keys against a Postgres database.

modules/doobie-pg · high confidence

Behavioural changes

Doobie integration refactored for version 1.0.0-RC13

The Doobie database integration in modules/doobie-core has been updated to support Doobie 1.0.0-RC13, introducing a new modular architecture with dedicated \DoobieMapping\, \DoobieMonitor\, and companion traits. This change replaces the previous \fromTransactor\ API with a new \mkMapping\ factory method (marking the old method as deprecated) and implements the updated Doobie Fragment and Meta APIs, enabling better support for non-Postgres database backends and structured table name handling.

modules/doobie-core · high confidence

Grackle 0.26.0 release with expanded database backends and Typelevel migration

This release updates the library to version 0.26.0 and officially migrates the project to the Typelevel organization, changing the Maven coordinates to org.typelevel. It introduces new database backends for Oracle and SQL Server (via Doobie) alongside existing Postgres and MySQL support, allowing users to query these databases directly. The project license has been updated to Apache 2.0, and CI infrastructure has moved from Travis CI to GitHub Actions. Additionally, the library now supports parsing GraphQL mutations and subscriptions, and the build configuration has been updated to use sbt-gsp and scalafmt 3.11.5.

(repo-wide) · high confidence

Skunk database backend refactored for cross-platform compatibility

The Skunk integration has been modularized and restructured to support non-Postgres database backends and cross-compilation to JavaScript and Native platforms. The core mapping logic (\SkunkMapping\) and test suites (\SkunkDatabaseSuite\, \SkunkSuites\) have been moved to shared and cross-platform directories, introducing a unified test framework that allows SQL-based tests to run against different database implementations. This change also includes the addition of subscription support via \SubscriptionMapping\ and \SubscriptionSuite\, enabling real-time data updates through PostgreSQL channels.

modules/skunk · high confidence

Standardized test data management with multi-dialect support

The test data directory has been restructured to support a unified dataset model across multiple database backends (PostgreSQL, Oracle, SQL Server, SQLite, H2, and MySQL). Test rows are now stored as shared CSV files, while dialect-specific schema definitions are kept in separate SQL scripts to handle type differences. This change introduces new SBT tasks (\newDataset\ and \checkTestData\) to facilitate dataset creation and validation, and updates the data generation pipeline to produce dialect-specific SQL scripts from the shared CSVs at container startup.

testdata · high confidence

Test coverage

Added GraphQL September 2025 conformance test suites; Added Oracle backend test suite; Added SQL Server backend test suite; Added Star Wars GraphQL test suite; Added comprehensive introspection test suite; Added comprehensive test suites for the GraphQL compiler; Added property-based test generators for AST components; Added property-based tests for Result laws; Added test coverage for GraphQL schema and type extensions; Added test coverage for query minimization and rendering; Added test coverage for schema validation and value rendering; Added test suite for Circe mapping and effect error handling; Added test suite for SDL parsing and schema definitions; Added test suite for composed GraphQL mappings; Added test suites for generic GraphQL mapping capabilities; Added test utilities for GraphQL response validation; Added tests for ValueEffect cursor construction; Added tests for mapping validation errors; Added tests for subscription mapping and execution; Added tests for validator stack safety.

Dependencies

Major dependency upgrade and build infrastructure overhaul

This change significantly updates the project's dependency versions and rebuilds the build configuration. Key library upgrades include Scala 3.3.8, Cats 2.13.0, Cats Effect 3.7.1, Circe 0.14.16, Doobie 1.0.0-RC13, FS2 3.14.0, and Http4s 0.23.38. It also introduces new database driver dependencies for MariaDB, SQL Server, MySQL, Oracle, SQLite, and H2, alongside updates to Skunk (1.0.0) and Shapeless. The build system has been migrated to sbt-typelevel, enabling cross-compilation for Scala 2.13 and 3, and integrates GitHub Actions workflows for CI, coverage reporting, and site publishing.

(dependencies) · high confidence

Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

How this codebase got here

Score

  • CAI 62 → 62 (-0.1)
  • Rubric changed (rubric-2026.10.5 → rubric-2026.11.2) — scores are not directly comparable.

Lenses

  • Code Health 69 → 69 (+0.0)
  • Architecture 88 → 87 (-1.3)
  • Maturity 51 → 51 (+0.0)
  • Readiness 69 → 69 (+0.1)
  • Security 82 → 72 (-9.2)
  • Performance 78 → 91 (+13.2)

Resolved (6)

  • Banned license: com.mysql:mysql-connector-j
  • Off-boarding risk: anonymized user #1
  • Outdated: org.http4s:http4s-circe_2.13
  • Outdated: org.http4s:http4s-dsl_2.13
  • Outdated: org.http4s:http4s-ember-client_2.13
  • Outdated: org.http4s:http4s-ember-server_2.13

New (2)

  • Dependency hygiene PARTLY measured — sbt declarations read, dependency currency not (Maven Central unreachable)
  • Off-boarding risk: anonymized user #1

Changes since last survey

  • 14 commits — 14 feature/other, 0 fixes

By area

  • (repo) — 7 commits
  • (root) — 6 commits
  • project/build.properties — 1 commit

Notable commits

  • change: Merge pull request #967 from typelevel/update/mariadb-java-client-3.5.11
  • change: Merge pull request #970 from typelevel/update/logback-classic-1.6.6
  • change: Merge pull request #972 from typelevel/update/sbt-1.13.1
  • change: Merge pull request #973 from typelevel/update/scala3-compiler-3.3.9
  • change: Merge pull request #974 from typelevel/update/sqlite-jdbc-3.54.1.0
  • change: Merge pull request #975 from typelevel/update/ojdbc8-23.26.4.0.0
  • change: Merge pull request #976 from typelevel/update/mssql-jdbc-13.6.2.jre11
  • change: Update logback-classic to 1.6.6
  • change: Update mariadb-java-client to 3.5.11
  • change: Update mssql-jdbc to 13.6.2.jre11
  • change: Update ojdbc8 to 23.26.4.0.0
  • change: Update sbt, scripted-plugin to 1.13.1
  • change: Update scala3-compiler, scala3-library, ... to 3.3.9
  • change: Update sqlite-jdbc to 3.54.1.0

Architecture

  • Unchanged — 0 containers · 1 contexts · 0 edges

Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

Survey your own repository

typelevel/grackle was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.

About this page

  • The score is its most recent published measurement, taken on 7 November 2026 at a pinned commit. It is not a live figure and does not change until the project is measured again.
  • Measured at commit 15f45166933a80e4a51380db08fd843d810fe3cd — the exact code this score is about.
  • Scored under rubric-2026.11.2 — the same rubric and the same method as every other entry in this index.
  • Measured by Canine Code Analyzer (cca.canine.dev) using cca measure-2026.11.3+preprod-5f8314471808.