Go library and CLI that parses ClickHouse-dialect SQL into a typed AST. Supports lexing, parsing, AST walking, round-trip formatting, and beautification. Use for query linting, static analysis, rewriting, access-control enforcement, schema validation, and SQL formatting.
AfterShip/clickhouse-sql-parser erreicht einen Gesundheitsindex von 86 von 100 und liegt damit im Bereich Exzellent. Am stärksten schneidet es bei Vitality (86/100) ab, am schwächsten bei Community & Adoption (53/100). Zuletzt vor 16 Tagen aktualisiert. Ein einzelner Mitwirkender trägt den Großteil der jüngsten Arbeit.
86
gesamt / 100
Exzellent
Software-Gesundheitsindex
Metriken werden auf einer standardisierten Skala von 1–100 in gewichtete Kategorien gruppiert. Der Gesamtwert beginnt als ihr gewichtetes Mittel, kalibriert auf die Verteilung des öffentlichen Registers, sodass die Stufen Perzentilbedeutung tragen; sobald öffentliche Evidenz die Richtlinie für Hochrisikojurisdiktionen auslöst, wird die Bewertung angepasst und erhält die Obergrenze Gefährdet von 34.
86
Außergewöhnlich93-100Die Spitzengruppe des Registers (≈ obere 5 %); erfüllt im Wesentlichen alle geprüften Kriterien
Gut65-79Gesund; Lücken sind begrenzt und beherrschbar
Mittel50-64Akzeptabel mit deutlichen Lücken; Überprüfung empfohlen
Schwach35-49Wesentliche Schwächen in mehreren Bereichen
Gefährdet20-34Erhebliche Schwächen; eine Übernahme erfordert Vorsicht
Kritisch1-19Schwerwiegende Probleme (aufgegeben, nur ein Maintainer, keine Hygiene)
Bewertungsprofil
Jede Achse ist eine Kategorie. Die Form zählt mehr als der Durchschnitt — ein gesundes Projekt füllt die gesamte Fläche, während ein Profil aus Spitzen und Kratern bedeutet, dass Stärke in einer Dimension Risiken in einer anderen verdeckt.
Der gewichtete Gesamtwert 72 wird auf der veröffentlichten Indexskala auf 86 kalibriert (Register-Kalibrierung 2026-08-02).
Dieses Repository wird von einer Organisation getragen — geteilte, rechenschaftspflichtige Trägerschaft, die jeden einzelnen Maintainer überdauern kann.
Release-Rhythmus — ein Release etwa alle 35,3 Tage
0/10
OpenSSF Scorecard: Signed-Releases — keine Daten
Verwendete Eingangsdaten
releases_count
24
latest_release_tag
v0.5.2
releases_from_tags
nein
days_since_latest_release
16
mean_days_between_releases
35,3
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): OpenSSF Scorecard: Signed-Releases. Die verbleibenden Gewichte wurden renormalisiert.
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): branch_protection, packaging, signed_releases. Die verbleibenden Gewichte wurden renormalisiert.
Direkte Abhängigkeiten ohne bekannte Advisories — keine direkte Abhängigkeit trägt ein bekanntes Advisory
0/25
Indirekte Abhängigkeiten ohne bekannte Advisories — transitive Menge in diesem Bereich nicht von Entwicklungs- und Test-Abhängigkeiten trennbar
0/40
Keine offenen Advisories — kein Advisory trägt ein Veröffentlichungsdatum
Verwendete Eingangsdaten
source
osv
advisories
0
affected_packages
0
assessed_packages
6
unassessed_packages
0
affected_by_severity
none
direct_affected_packages
0
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Indirekte Abhängigkeiten ohne bekannte Advisories, Keine offenen Advisories. Die verbleibenden Gewichte wurden renormalisiert. 6 aufgelöste Abhängigkeiten wurden mit OSV abgeglichen. Dieses Repository veröffentlicht kein Paket, das der Index auflöst; bewertet wurde daher der Abhängigkeitsgraph des Repositorys. Dieser Graph vermischt Entwicklungs- und Test-Pins mit ausgelieferten Abhängigkeiten, daher werden nur die deklarierten Laufzeit-Abhängigkeiten bewertet; transitive Befunde werden als Kontext ausgewiesen und fließen nicht in die Bewertung ein. Erreichbarkeit wird nicht analysiert.
Wie gut ist das Repository dafür ausgestattet, mit KI-Coding-Agenten entwickelt und gepflegt zu werden? Trägt ein bewusst kleines Gewicht (4 %): Agenten-Tooling ist ein echtes Pflegesignal, doch ein Repository ohne jedes Signal kann weiterhin 100/100 erreichen.
Handhabbare Dateigrößen — 3/32 Quelldateien über 60 KB
Verwendete Eingangsdaten
primary_language
Go
largest_source_bytes
123.155
source_files_sampled
32
oversized_source_files
3
Eckdaten
242GitHub-Sterne
31Mitwirkende
95Commits, letzte 12 Monate
16Tage seit letztem Push
24Releases
1Bus-Faktor
0offene Issues
GoPaket-Ökosysteme
Warnungen zur Datenerhebung
Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
Weitere Details
Stern- und Fork-Verlauf 0 ★ / 51 ⇿
0Sterne
51Forks
23Releases
Wann jeder Stern und Fork hinzugefügt wurde, von GitHub erfasst und nach Tagen gruppiert. Das kumulierte Wachstum steht direkt über den täglichen Zugängen, aus denen es besteht, sodass beide gegeneinander lesbar sind: stetiger organischer Zuwachs sieht ganz anders aus als ein abrupter, kurzlebiger Ausschlag. Wo dieser Unterschied messbar ist, wird er als Wachstumsauthentizität ausgewiesen.
Major 0Minor 2Patch 21
Jeder Punkt umfasst 3 Tage.
OpenSSF Scorecard 6.3 / 10
6.3Gesamtwert
Unabhängige, werkzeugneutrale Sicherheitsbewertung durch das quelloffene OpenSSF Scorecard. Jede Prüfung honoriert eine Sicherheits-Praxis, nicht das Werkzeug eines bestimmten Anbieters. Prüfungen, die Scorecard nicht ermitteln konnte, sind mit k. A. markiert und vom Sicherheitswert ausgeschlossen (nie als null gezählt).Scorecard v5.5.0 · 2026-07-27 17:24 UTC
Vollständig aufgelöster Abhängigkeitssatz aus dem GitHub-Abhängigkeitsgraphen: 2 direkte und 4 indirekte (transitive) Pakete. Die transitive Hülle ist vollständig, wenn das Repository eine Lockfile eincheckt.
Registry
Paket
Version
Beziehung
Go
github.com/sebdah/goldie/v2
v2.5.3
direkt
Go
github.com/stretchr/testify
v1.8.4
direkt
Go
github.com/davecgh/go-spew
v1.1.1
indirekt
Go
github.com/pmezard/go-difflib
v1.0.0
indirekt
Go
github.com/sergi/go-diff
v1.0.0
indirekt
Go
gopkg.in/yaml.v3
v3.0.1
indirekt
Abhängigkeits-Advisories 0
Dieses Repository veröffentlicht kein vom Index auflösbares Paket, daher wurde sein eigener Abhängigkeitsgraph bewertet – 6 Pakete, darunter auch Entwicklungs- und Test-Pins, die nie ausgeliefert werden: 0 tragen bekannte Advisories, davon 0 direkte.
Keine bekannten Advisories betreffen die bewerteten Abhängigkeiten.
Ein Advisory bedeutet, dass die im Abhängigkeitsgraphen erfasste Version in den betroffenen Bereich eines Advisories fällt. Erreichbarkeit wird nicht analysiert, und der Graph enthält Entwicklungs- und Test-Pins — ein Fund kann das Werkzeug betreffen und nicht die ausgelieferte Software.
JSON-Rohbericht maschinenlesbar
{
"data": {
"repo": {
"topics": [
"clickhouse",
"go",
"sql-parser"
],
"is_fork": false,
"size_kb": 1724,
"has_wiki": true,
"homepage": null,
"languages": {
"Go": 562651,
"Makefile": 499
},
"pushed_at": "2026-07-11T07:11:11Z",
"created_at": "2023-09-22T02:56:16Z",
"owner_type": "Organization",
"updated_at": "2026-07-17T07:40:47Z",
"description": "Go library and CLI that parses ClickHouse-dialect SQL into a typed AST. Supports lexing, parsing, AST walking, round-trip formatting, and beautification. Use for query linting, static analysis, rewriting, access-control enforcement, schema validation, and SQL formatting.",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "master",
"license_spdx_raw": "MIT",
"primary_language": "Go",
"significant_languages": [
"Go"
]
},
"owner": {
"blog": "https://www.aftership.com",
"name": "AfterShip",
"type": "Organization",
"login": "AfterShip",
"company": null,
"location": "Hong Kong",
"followers": 169,
"avatar_url": "https://avatars.githubusercontent.com/u/1334231?v=4",
"created_at": "2012-01-16T16:27:21Z",
"is_verified": null,
"public_repos": 81,
"account_age_days": 5306
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v0.5.2",
"kind": "patch",
"published_at": "2026-07-11T07:11:11Z"
},
{
"tag": "v0.5.1",
"kind": "patch",
"published_at": "2026-04-21T03:40:57Z"
},
{
"tag": "v0.5.0",
"kind": "minor",
"published_at": "2026-03-18T02:34:31Z"
},
{
"tag": "v0.4.19",
"kind": "patch",
"published_at": "2026-01-26T10:15:35Z"
},
{
"tag": "v0.4.18",
"kind": "patch",
"published_at": "2025-12-25T04:01:42Z"
},
{
"tag": "v0.4.17",
"kind": "patch",
"published_at": "2025-11-20T04:06:51Z"
},
{
"tag": "v0.4.15",
"kind": "patch",
"published_at": "2025-11-01T06:08:32Z"
},
{
"tag": "v0.4.14",
"kind": "patch",
"published_at": "2025-10-10T05:36:51Z"
},
{
"tag": "v0.4.13",
"kind": "patch",
"published_at": "2025-09-17T02:06:48Z"
},
{
"tag": "v0.4.11",
"kind": "patch",
"published_at": "2025-08-27T05:40:15Z"
},
{
"tag": "v0.4.10",
"kind": "patch",
"published_at": "2025-06-10T10:12:25Z"
},
{
"tag": "v0.4.9",
"kind": "patch",
"published_at": "2025-05-08T13:56:18Z"
},
{
"tag": "v0.4.8",
"kind": "patch",
"published_at": "2025-04-23T11:13:44Z"
},
{
"tag": "v0.4.6",
"kind": "patch",
"published_at": "2025-04-18T04:14:41Z"
},
{
"tag": "v0.4.5",
"kind": "patch",
"published_at": "2025-03-24T11:08:27Z"
},
{
"tag": "v0.4.4",
"kind": "patch",
"published_at": "2025-02-28T03:07:04Z"
},
{
"tag": "v0.4.3",
"kind": "patch",
"published_at": "2025-02-19T09:11:19Z"
},
{
"tag": "v0.4.1",
"kind": "patch",
"published_at": "2024-12-25T07:04:48Z"
},
{
"tag": "v0.4.0",
"kind": "minor",
"published_at": "2024-11-29T09:12:06Z"
},
{
"tag": "v0.3.8",
"kind": "patch",
"published_at": "2024-10-08T01:50:29Z"
},
{
"tag": "v0.3.7",
"kind": "patch",
"published_at": "2024-09-26T10:21:42Z"
},
{
"tag": "v0.3.6",
"kind": "patch",
"published_at": "2024-09-04T07:03:46Z"
},
{
"tag": "v0.3.4",
"kind": "patch",
"published_at": "2024-06-29T11:59:31Z"
},
{
"tag": "v0.3.1",
"kind": "patch",
"published_at": "2024-01-09T07:55:40Z"
}
],
"recent_commits": [
{
"oid": "e4c6e11fcec9a7140ef53835fae0728b2f304a3c",
"body": null,
"is_bot": false,
"headline": "Fix traversal of semantic AST children (#285)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T07:23:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dcf2383959c8fbf160b77be4d7251a22f650e2e7",
"body": null,
"is_bot": false,
"headline": "Traverse JSON type options",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T06:49:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a1569691e05fbe2b6625e8f847ff78635ea4c2e8",
"body": "The two traversal engines each encode every node's children by hand, and\nthe existing drift test only asserts that both engines know the same\nnode TYPES - it cannot see a child FIELD one engine traverses and the\nother forgot. A new static test compares, per node type, the fields\nreferenced by Accept\n[…]\nd outside the destination's Enter/Leave bracket.\n The clause now owns its child, and its End() includes the schema.\n\nNo golden fixture changed.\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix Accept/Walk field-level drift and InsertStmt End panic (#284)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T04:11:42Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "38158f99b1514f8599cdad42e0d5551d8e46cdf5",
"body": null,
"is_bot": false,
"headline": "Split keywords into reserved and non-reserved sets (#282)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T04:06:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4feeec5fb6921957ff35ba892d0c425c37a6604f",
"body": "…ionary nodes (#283)\n\nPositions are stamped from caller-supplied `pos` parameters or read\nafter the relevant token was already consumed, producing wrong or\noverlapping spans in several nodes:\n\n- parseRatioExpr passed the numerator's pos to the denominator too, so\n `SAMPLE 1/2` produced two literals\n[…]\nly position-field values plus the two\nnew fields (NullEnd, AttrEnd); no format output changed. Span\nassertions live in the new position_test.go.\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix position tracking across ratio, IS NULL, GROUP BY, ALTER and dict…",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T03:02:12Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "6084020a9a7c9c62c6410565b22daf5a67900fc7",
"body": "…280)",
"is_bot": false,
"headline": "Fix number lexing, unterminated block comments and non-ASCII bytes (#…",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-05T02:46:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5c3069235a044b81c69aad90b00ad19db7371857",
"body": "The precedence table disagreed with ClickHouse in several places and two\noperators were unreachable. All of these misparses round-tripped to the\nsame SQL text, so the golden tests never caught them:\n\n- Lambda `->` bound tightest instead of loosest: `x -> x + 1` parsed as\n `(x -> x) + 1`. It now bin\n[…]\nBetweenClause.Not,\nSelectQuery.Intersect); no format output changed. New structural tests\nin precedence_test.go assert the tree shapes directly.\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix expression precedence for lambda, ternary and NOT (#279)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-07-04T13:57:38Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "4932a6cbf9b58c1d2db1d91a100e893fc3e00853",
"body": "l.lastToken and p.last() actually hold the *current* lookahead token -\nthe one the parser is looking at but has not consumed - not a\npreviously-consumed token. Likewise l.current held the input byte\noffset, not a token. Rename for accuracy, no behavior change:\n\n- lexerState.current (int) -> offse\n[…]\nLexer.consumeToken used\nto disambiguate unary +/- - is named prevToken.\n\nAlso give TokenKindDot its missing TokenKind type annotation.\n---------\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Rename lexer state to match what it holds (#277)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-14T03:39:26Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "558390dcbb3ef056e155d297a7efb74e448e98bf",
"body": "Accept/ASTVisitor and Walk/WalkFunc are two independent traversal\nengines that encode every node's children separately, so a new AST node\ntype added to one can silently be missing from the other. Add a static\ntest that parses the package source and asserts every type with an\nAccept method has both a\n[…]\ny\nafter visiting the sample ratio, so VisitJoinTableExpr was never called\nfor table expressions carrying a SAMPLE clause. Add a regression test.\n\nCo-authored-by: Claude Fable 5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Add drift test keeping ASTVisitor and Walk traversals in sync (#276)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-12T10:53:39Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "3c3822c5e43a9f04244d9599fc8a1c4bd7ba8e2d",
"body": "Replace the stringly-typed parse error and its per-error full-input\nrescan with a typed *ParseError that carries the byte offset, 1-based\nline/column, the offending token, and the expected token kinds/keyword.\n\n- error.go: ParseError type; Error() renders the line:col message plus a\n caret, matchin\n[…]\nrror\nmessages were reworded; callers can now errors.As(err, &ParseError{}).\n\nCo-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Opus 4.8 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Add structured ParseError with O(log n) position lookup (#274)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-10T13:23:42Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "5df9a6cbb677119e4b3f58133b7e060b059881cd",
"body": "`wrapError` walks `p.lexer.input[i]` for `i < int(p.Pos())` to compute the\nerror line/column. At EOF `p.Pos()` can exceed `len(input)`, so on input like\n`CREATE--` (a trailing comment leaves the position past the end) it panics\nwith \"index out of range\".\n\nClamp the loop bound to `len(p.lexer.input)`\n[…]\n it panicked before\nthe fix and now returns a proper error.\n\nCo-authored-by: Claude Opus 4.8 <noreply@anthropic.com>\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>",
"is_bot": false,
"headline": "Fix index-out-of-range panic in wrapError at EOF (#272)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-10T06:55:13Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "4d7ccd6048d67b2fb2a741b1acedf9b30e5111f5",
"body": "`consumeMultiLineComment` looped on `!l.isEOF()` (which checks `l.current`)\nwhile only advancing the local index `i`, so on an unclosed comment like\n`/* unterminated` the lexer spun forever — a DoS hang.\n\nLoop on `l.peekOk(i)` instead so it terminates at end of input.\n\nAdd TestConsumeUnterminatedComment to reproduce: it drains the lexer in a\ngoroutine with a timeout, so a regression fails fast instead of hanging.\n\nCo-authored-by: Claude Opus 4.8 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix infinite loop on unterminated block comment (#271)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-10T06:49:32Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "35710d6df411a1eed5c3fc9abe435a9cfcaaacb1",
"body": "Error messages built with `fmt.Errorf(\"... %q\", p.last().String)` panic when\nthe lexer is at EOF, because `p.last()` is nil. Inputs like `ALTER `,\n`SELECT*FROM A(0A` and `SET A=` triggered this.\n\nAdd a nil-safe `lastTokenString()` helper (mirroring `lastTokenKind()`) that\nreturns \"<EOF>\" when there \n[…]\nare left untouched.\n\nAdd the inputs above to TestParser_InvalidSyntax to reproduce: they panicked\nbefore the fix and now return a proper error.\n\nCo-authored-by: Claude Opus 4.8 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix nil-pointer dereference when formatting errors at EOF (#273)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-06-10T06:46:56Z",
"body_truncated": true,
"is_coding_agent": true
},
{
"oid": "88f462ccee248e6675fb2c8e3bd9828409cdf763",
"body": "…able in CREATE MATERIALIZED VIEW (#270)\n\n1. Column list before ENGINE (new):\n ClickHouse SHOW CREATE TABLE for refreshable materialized views with\n ENGINE (e.g. Memory) outputs the column list between REFRESH and ENGINE:\n\n CREATE MATERIALIZED VIEW db1.mv_name\n REFRESH EVERY 1 SECOND\n \n[…]\nialized_view_rmv_engine_with_columns.sql (column list + ENGINE)\n- create_materialized_view_rmv_depends_on_multi.sql (multi-table DEPENDS ON)\n- All 21 MV syntax variants tested, all existing tests pass",
"is_bot": false,
"headline": "Fix should allow column list before ENGINE and fix DEPENDS ON multi-t…",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2026-05-15T10:35:05Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "33c6bf25c7c5bd86bec60109e38db0b15a2cd3e7",
"body": "Extend keyword-as-identifier handling to recognize end-of-statement\n(EOF or `;`) as a disambiguator in expression position, so projections\nlike `SELECT case`, `SELECT case;`, or `SELECT limit` parse as bare\ncolumn refs — matching ClickHouse server (verified against 25.10.7.6,\nwhich returns UNKNOWN_I\n[…]\n, because\nmatchTokenKind(TokenKindIdent) coerces TokenKindKeyword and so\nparseIdent accepts keyword tokens as alias names; added a comment at\nthe AS branch of parseSelectItem to make that intentional.",
"is_bot": false,
"headline": "Allow reserved keywords as bare column names in SELECT list (#269)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2026-05-12T03:39:14Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "c1775906aa01bdf7c4b63112a0a9185ebc184ab2",
"body": "…(#268)\n\nClickHouse accepts `SELECT a, FROM t` (e.g. when a column is commented\nout with `--`). Break the SELECT-item loop after consuming a comma if\nthe next token is a clause-starting keyword (FROM, WHERE, GROUP, etc.).\nFixes incorrect AST for existing CREATE MATERIALIZED VIEW fixtures\nwhere FROM was previously consumed as a bare select expression.",
"is_bot": false,
"headline": "Fix should allow trailing comma in SELECT list before clause keyword …",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2026-05-11T09:37:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9f798c0f67a9c2c7ce58cdca9cd43b22408c1622",
"body": null,
"is_bot": false,
"headline": "Add support of REGEXP as binary operator (#267)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2026-05-11T02:02:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1930f34593d4559288e7ace62d1f6808baec78c3",
"body": null,
"is_bot": false,
"headline": "fix: ensure projections can have either an order by or a group by (#266)",
"author_name": "Mark deVilliers",
"author_login": "mdevilliers",
"committed_at": "2026-04-25T05:02:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8ce1476f64ea6b1504ba43802fc472f00771e9b7",
"body": "CREATE VIEW in ClickHouse supports COMMENT between the schema and AS SELECT:\n\n CREATE VIEW db.v (columns) COMMENT '{...}' AS SELECT ...\n\nThe parser previously failed with 'expected EOF or ; but got COMMENT'.\n\nChanges:\n- Add Comment field to CreateView struct (ast.go)\n- Parse COMMENT clause in parse\n[…]\nView before AS (parser_view.go)\n- Format COMMENT in CreateView.FormatSQL (format.go)\n- Add test case: create_view_with_comment.sql\n- Update golden files for existing view tests (new nil Comment field)",
"is_bot": false,
"headline": "Add COMMENT support to CREATE VIEW parser (#265)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2026-04-17T15:15:09Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "d5e88a6635f346b9fbcbe8c149f17393432216d3",
"body": null,
"is_bot": false,
"headline": "Add support for CREATE USER VALID UNTIL clause (#264)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-04-16T06:17:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "120ff65369024b9ae49f98094e3c659d5fff05e3",
"body": "ClickHouse 26.2+ changed SHOW CREATE TABLE output to place COMMENT\nbefore AS SELECT, while 25.x places it after. The parser only\nsupported COMMENT after AS SELECT, causing parse failures on 26.2+.\n\nNow tries COMMENT in both positions:\n- Before AS SELECT (ClickHouse 26.2+ SHOW CREATE TABLE format)\n- After AS SELECT (ClickHouse 25.x SHOW CREATE TABLE format)\n\nThis closes #261.",
"is_bot": false,
"headline": "Support COMMENT before AS SELECT in CREATE MATERIALIZED VIEW (#262)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2026-04-09T02:29:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5a72214bb365ba3e3d9d11e24fe6a3d1c933b09c",
"body": "Co-authored-by: Kemal Hadimli <disq@users.noreply.github.com>",
"is_bot": false,
"headline": "fix: Panic on invalid number as query (#260)",
"author_name": "Kemal",
"author_login": "disq",
"committed_at": "2026-03-28T02:35:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3d0a96950058795479f364e3ac8411f3b3ac95cc",
"body": null,
"is_bot": false,
"headline": "Add support for window names in WindowExpr (#259)",
"author_name": "Chinh Nguyen",
"author_login": "chinhnguyenh",
"committed_at": "2026-03-18T09:30:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4a3c96ea2fdf18439bc542808de83af96909dbca",
"body": "parseDistinctOn() was calling parseIdent() which only handles simple\nidentifiers. Queries like DISTINCT ON (t.id, t.name) would fail because\nthe dot was not recognized. Changed to parseExpr() so that any valid\ncolumn expression (including table.column references) is accepted.",
"is_bot": false,
"headline": "Support expressions (dotted column refs) in `DISTINCT ON` (#258)",
"author_name": "Kemal",
"author_login": "disq",
"committed_at": "2026-03-17T01:44:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d468e13bb73958e72f7b24bbc0a6909fee6bdfeb",
"body": null,
"is_bot": false,
"headline": "Fix SQL code block formatting in README",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-14T13:45:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5d7a71f04bbe2df11949b2dd47e8546b1fcb7c28",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add beautify format for ALTER ROLE and CREATE ROLE SETTINGS (#256)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-14T13:43:18Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "461102b0a504c2ae55bc6ed7b63f9b5efbd92d1f",
"body": null,
"is_bot": false,
"headline": "Improve CREATE LIVE VIEW format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T09:06:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "af5073cb95c77cc02c9aa731990bbe5d6c6ca952",
"body": null,
"is_bot": false,
"headline": "Improve ALTER TABLE CLEAR * format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T08:54:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "74e0ba3421fabf351f747103f895585eff3c1cd5",
"body": null,
"is_bot": false,
"headline": "Fix IF EXISTS order in ALTER TABLE",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T08:44:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "089230e39f9b6ef20f649da93d9146865982d989",
"body": null,
"is_bot": false,
"headline": "Improve the ALTER TABLE format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T08:37:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ece3a1156a682625c379019489f710c4da858bce",
"body": null,
"is_bot": false,
"headline": "Improve the CREATE MATERIALIZED VIEW format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T07:51:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a8128443e0ec06c5e01185b7b37401031f6d2528",
"body": null,
"is_bot": false,
"headline": "Improve the CREATE DIRECTORY format",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T06:51:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf5be1223055e9f0acadb022d9d0ea6394499420",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add beautify format support for CREATE DICTIONARY statements (#253)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T06:37:42Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "17e829da71577dc907179e4c0a7575c9e9c8957d",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add line breaks for ON CLUSTER and ALTER clauses in beautify mode (#251)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T06:29:21Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "b2d2addf27bd3a308c96fafa41dd2b0007fd43b3",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Document `-beautify` flag with example (#249)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T04:14:56Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "3b8db2800ecd1373ee213ff59bebac0c9b573914",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add chaining methods to formatter for customizable indentation (#248)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:58:19Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "4b92d7051063f32120136134a5211b1a669175da",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add beautify format support for CREATE USER statements (#247)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:57:09Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "033e8735215a618cd6cc81ca473630d28d18ae1f",
"body": "…#245)\n\n---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>\nCo-authored-by: hulk <hulk.website@gmail.com>",
"is_bot": false,
"headline": "Add line break and indentation for SETTINGS clause in beautify mode (…",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:54:17Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "1cf1e3d21420b15990fca76c07dfb522926cec93",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add line break before column list in INSERT INTO formatting (#246)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:43:29Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "6d0175c1622d39c3d6d55c4b708cb38a1cfdc112",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add line break and indentation to FROM clause formatting (#244)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2026-02-13T03:25:36Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "50c0046c45cecb74ec09fea1b88c2cc73798589e",
"body": null,
"is_bot": false,
"headline": "Add ident format for JOIN",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-13T02:07:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2588297e03fd083e7946b7a2132723150e302fe2",
"body": null,
"is_bot": false,
"headline": "Add ident format for GROUP BY",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-12T13:54:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "95a195fc6baf73b5a24a35df7d8684e14183debe",
"body": null,
"is_bot": false,
"headline": "Add the beautify format SQL gold files",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-12T13:47:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "925428d81eb74cbb0922aa51fc08a60d3231dffb",
"body": null,
"is_bot": false,
"headline": "Update AGNETS.md",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-12T02:29:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9275c63ba11b26ac10573d824620edb647ed1496",
"body": null,
"is_bot": false,
"headline": "Introduce `FormatSQL` API to allow customizing different formats",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2026-02-11T12:33:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e5d75c5c2d9e30a9028f9577a4074428c3ea7169",
"body": "Co-authored-by: Telman Rzaev <ttrzaev@avito.ru>",
"is_bot": false,
"headline": "Add support for CREATE NAMED COLLECTION statements (#235) (#236)",
"author_name": "Telman",
"author_login": "St0rmPetrel",
"committed_at": "2026-01-29T02:37:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "078beb471ccc1266720e35a4f1a5e46d0c90b60b",
"body": null,
"is_bot": false,
"headline": "Add support for nested named/unnamed tuple types (#233)",
"author_name": "James Riley Wilburn",
"author_login": "rhino1998",
"committed_at": "2026-01-29T02:10:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fbea4206789fdefb5f9dbde0afa8cb1e303db6a5",
"body": null,
"is_bot": false,
"headline": "Fix parsing failure when having multiple ttl expressions (#234)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-01-26T10:14:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b13080fd6ad5bba8f711da80fae212738c019941",
"body": "Co-authored-by: Claude Sonnet 4.5 <noreply@anthropic.com>",
"is_bot": false,
"headline": "Add support for SETTINGS clause in ALTER TABLE ADD COLUMN (#232)",
"author_name": "Lance",
"author_login": "Lance726",
"committed_at": "2026-01-23T08:59:41Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "2154d0b75f973039de1be7dfe87cb29ef4f88546",
"body": null,
"is_bot": false,
"headline": "Fix CASE statement WHEN spacing (#231)",
"author_name": "James Riley Wilburn",
"author_login": "rhino1998",
"committed_at": "2026-01-23T01:57:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c35e37e247556eabda6e9c7ce945b7ef79bbe18f",
"body": null,
"is_bot": false,
"headline": "Allow ARRAY JOIN to be interleaved with other JOIN statements (#230)",
"author_name": "Herman Schaaf",
"author_login": "hermanschaaf",
"committed_at": "2026-01-22T13:06:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "264c31243b0e9c19f3550ff8c134b262e03e78da",
"body": null,
"is_bot": false,
"headline": "Fix support for multiple array join statements (#229)",
"author_name": "Herman Schaaf",
"author_login": "hermanschaaf",
"committed_at": "2026-01-21T01:50:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "47921fec43ac891be7f0bca5d2bc590cbc3dc25b",
"body": null,
"is_bot": false,
"headline": "Add support for concat operator (#228)",
"author_name": "James Riley Wilburn",
"author_login": "rhino1998",
"committed_at": "2026-01-16T12:32:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "39f4fac7b9e2848c6e45a80859ed81f69ed8473c",
"body": "Co-authored-by: Copilot Autofix powered by AI <62310815+github-advanced-security[bot]@users.noreply.github.com>",
"is_bot": false,
"headline": "Fix workflow does not contain permissions (#227)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2026-01-13T13:24:14Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "7d8113246f59b6e5502abda633ea7955d37316eb",
"body": null,
"is_bot": false,
"headline": "Add support for OFFSET clause without LIMIT (#226)",
"author_name": "James Riley Wilburn",
"author_login": "rhino1998",
"committed_at": "2026-01-13T02:26:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b233fe1ba6f3d37dd52465fd142d744f40edcad5",
"body": null,
"is_bot": false,
"headline": "Add support of parsing Tuple type in DDL (#225)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-12-25T04:00:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8e07af72ca754e780b85e440f7667c2ce4177ce1",
"body": null,
"is_bot": false,
"headline": "Support empty parentheses in index type definitions (#224)",
"author_name": "Lance",
"author_login": "Lance726",
"committed_at": "2025-12-09T10:23:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "827df05967469ee90905688e084e57e5ac723611",
"body": null,
"is_bot": false,
"headline": "Delete .github/workflows/claude.yaml",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-12-08T13:22:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5fc8fac1180a342b28c263a92873a52792c51c0b",
"body": null,
"is_bot": false,
"headline": "Fix regex expression wasn't allowed in EXTRACT (#223)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-12-06T16:05:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ff82e4c7015b870e669ca737e9f7375efeb77b4c",
"body": null,
"is_bot": false,
"headline": "Update VERSION constant to 0.4.17",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-12-05T08:45:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fd7b5d02ddec261c8576ae3f3f5f3c5d3d4e4f17",
"body": "Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Fix: Send error messages to stderr instead of stdout (#221)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-12-01T09:36:39Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "699e78fbe72209e69fc8b79efa334a999c1c81d7",
"body": "* Removing unwanted code\n\nSigned-off-by: Sharad Gaur <sharadgaur@gmail.com>\n\n* Adding to walk.go\n\nSigned-off-by: Sharad Gaur <sharadgaur@gmail.com>\n\n---------\n\nSigned-off-by: Sharad Gaur <sharadgaur@gmail.com>",
"is_bot": false,
"headline": "Fix refreshable View with named parameters (#217)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2025-11-21T02:45:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3f5e89de1f9b8416ca97814b67c5e30fc29475f6",
"body": "ALTER TABLE foo MODIFY QUERY <an invalid query> crashed the parser with a sigsegv due to a missing error check; this commit adds the missing check and a regression test.",
"is_bot": false,
"headline": "bug: fix a crash with an invalid query following MODIFY QUERY (#215)",
"author_name": "Sean Gillespie",
"author_login": "swgillespie",
"committed_at": "2025-11-20T01:52:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4466b5c995e43b1d6969da59dd3d565db3ab9e6e",
"body": "This commit adds support for using table functions like remoteSecure()\nand remote() in CREATE TABLE AS statements when column definitions are\npresent, and fixes support for AS SELECT without parentheses.\n\nThe parser now supports table creations such as:\n- CREATE TABLE (...) AS remoteSecure('host', 'db', 'table', 'user', 'pass')\n- CREATE TABLE (...) AS remote('host', 'db', 'table')\n- CREATE TABLE AS SELECT ... (without parentheses)\n- CREATE TABLE (...) AS SELECT ... (without parentheses)",
"is_bot": false,
"headline": "Add support for table functions in CREATE TABLE AS statements (#214)",
"author_name": "Sean Gillespie",
"author_login": "swgillespie",
"committed_at": "2025-11-19T04:11:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8ca8a97ad9b1d43e0faf0ede75977692e9199795",
"body": null,
"is_bot": false,
"headline": "Add support of parsing SETTING boolean values (#213)",
"author_name": "Mark deVilliers",
"author_login": "mdevilliers",
"committed_at": "2025-11-18T02:02:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "42fd0bb737216c665970901ba10215bc7f817e7c",
"body": null,
"is_bot": false,
"headline": "Fix nil pointer for replicated database engine (#212)",
"author_name": "Sebastian Rabenhorst",
"author_login": "rabenhorst",
"committed_at": "2025-11-17T12:57:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c9e8bb49915ee6fcdee7589ba78447b09a46c40e",
"body": "Compression codecs such as `DoubleDelta` do not require any additional positional parameters and infer defaults, such as `CODEC(DoubleDelta)`. This commit doesn't continue parsing a codec if there's no comma indicating additional parameters to the codec.",
"is_bot": false,
"headline": "Parse compression codecs with no parameters (#197)",
"author_name": "Sean Gillespie",
"author_login": "swgillespie",
"committed_at": "2025-11-14T02:07:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "06f1e259f9f56adc99daa7487c8645d07de5ccab",
"body": null,
"is_bot": false,
"headline": "Add WITH FILL Support in ORDER BY (#211)",
"author_name": "Flo",
"author_login": "Flo4604",
"committed_at": "2025-11-07T13:22:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e1db7786cb3ebbb68c5fadcf051d4fdaea49f96b",
"body": "Signed-off-by: Sharad Gaur <sharadgaur@gmail.com>",
"is_bot": false,
"headline": "Adding support for parsing COMMENT for dictionary (#210)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2025-11-07T01:44:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "405710174ae922d12df730901af1b8e8045a5514",
"body": null,
"is_bot": false,
"headline": "Fix string escape sequences in lexer (#209)",
"author_name": "Su Yong Chang",
"author_login": "waterdrag0n",
"committed_at": "2025-11-03T09:54:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "60759d4f18e287a89055e726fff97d00c5fca3bb",
"body": null,
"is_bot": false,
"headline": "Support multiple WINDOW definitions; expand window function tests (#208)",
"author_name": "A.J. Ruckman",
"author_login": "ajruckman",
"committed_at": "2025-10-30T02:45:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0b8b2e33d8fe85e4a78ca782aea35cc51941698e",
"body": null,
"is_bot": false,
"headline": "Support QBit data type via simplified identifier handling (#207)",
"author_name": "A.J. Ruckman",
"author_login": "ajruckman",
"committed_at": "2025-10-29T01:57:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5c0f9cced3e636c8e044293c3dd4e5b0a5671f42",
"body": "…206)",
"is_bot": false,
"headline": "Allow to use the optional `IN PARTITION` expression in ALTER TABLE (#…",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-10-28T11:48:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e31c88c056396d2a737f0931997aeb721aa3b54a",
"body": null,
"is_bot": false,
"headline": "Add support of ALTER TABLE DELETE/UPDATE mutations (#203)",
"author_name": "A.J. Ruckman",
"author_login": "ajruckman",
"committed_at": "2025-10-27T02:16:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "78ff34b55d7055500025955b677a7eed5e19597f",
"body": "…#202)",
"is_bot": false,
"headline": "Fix typed placeholder lookahead; parse WHERE in SELECT without FROM (…",
"author_name": "A.J. Ruckman",
"author_login": "ajruckman",
"committed_at": "2025-10-27T02:03:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "61525d54cccb3b901889a7ed4de75a03eb8049e5",
"body": "---------\n\nCo-authored-by: wanghao <wang_hao11@venusgroup.com.cn>\nCo-authored-by: git-hulk <hulk.website@gmail.com>",
"is_bot": false,
"headline": "Fix the printing order of the EngineExpr.String() method (#201)",
"author_name": "design",
"author_login": "whscout",
"committed_at": "2025-10-11T05:34:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ac0ab090ec1abc8eea46158a884325c3a5949a28",
"body": null,
"is_bot": false,
"headline": "Fix `SELECT` keyword inside functions (#200)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-10-08T08:16:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c884bd5998ae473b5c8daf76bf307afc03b62731",
"body": null,
"is_bot": false,
"headline": "Support single-quoted table names (#199)",
"author_name": "Mariano Gappa",
"author_login": "marianogappa",
"committed_at": "2025-10-02T14:57:40Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "341967c2fa4c03f3635b18f3aa7d708033b3e47f",
"body": null,
"is_bot": false,
"headline": "Add support of the type hint parsing in JSON column type (#196)",
"author_name": "Piyush Singariya",
"author_login": "piyushsingariya",
"committed_at": "2025-09-29T07:27:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ee69fcc25f12ed75aa9bb18a224019c23e3bee40",
"body": "Add support for walking DistinctOn AST nodes in the Walk function to ensure proper traversal of SELECT DISTINCT ON expressions.\n\n🤖 Generated with [Claude Code](https://claude.ai/code)\n\nCo-authored-by: Claude <noreply@anthropic.com>",
"is_bot": false,
"headline": "Fix Walk logic for DistinctOn clause (#195)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-09-22T06:38:57Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "b8659ca21d60b9cda4ce1575d1a8ce5501e5315f",
"body": null,
"is_bot": false,
"headline": "feat: add support for `SELECT DISTINCT ON(…)` (#194)",
"author_name": "Ben Blackmore",
"author_login": "bripkens",
"committed_at": "2025-09-21T10:25:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4350d2eb704a3f45b75c13aae52cd2a7bda956b3",
"body": null,
"is_bot": false,
"headline": "Fix allow using keywords as alias for columns (#193)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-09-19T02:09:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "752d6e78430b01565d7f5abcee78e8d624318ea5",
"body": null,
"is_bot": false,
"headline": "Fix parsing on multiple `union distinct` and `except` (#192)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-09-18T01:57:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7bdfc482fb1b7e4e1992a0d045540738a9dffa2b",
"body": null,
"is_bot": false,
"headline": "Fix `Walk` logic for `When` clause (#190)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-09-17T02:05:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "18938455f91c1989f90258f35879c24a033e4fbc",
"body": null,
"is_bot": false,
"headline": "Fix shouldn't stop on `nil` values when traversing the AST (#191)",
"author_name": "Erez Rokah",
"author_login": "erezrokah",
"committed_at": "2025-09-17T02:03:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "294aafbcb0009df3dad13ae5f6d4420feff6c456",
"body": null,
"is_bot": false,
"headline": "Allow using JSON path in select results (#189)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-09-11T05:32:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "171c3e84444ffbf23e1394260766f3b6caef0868",
"body": "---------\n\nSigned-off-by: Sharad Gaur <sharadgaur@gmail.com>",
"is_bot": false,
"headline": "Fix INDEX column spacing bug (#186)",
"author_name": "Sharad Gaur",
"author_login": "sharadgaur",
"committed_at": "2025-09-01T04:16:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf749932c1fe60e4c4fdff85dac1aab795d60b9b",
"body": null,
"is_bot": false,
"headline": "Add ALTER TABLE MODIFY/RESET SETTING syntax support (#185)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-27T05:39:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d81858052d5142f93bf6297a14cce29edff68bac",
"body": null,
"is_bot": false,
"headline": "Support `DESCRIBE TABLE` syntax (#183)",
"author_name": "Dejan Miletic",
"author_login": "dejanmltc",
"committed_at": "2025-08-22T10:29:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2590403d7c446d0f6a44032b9932c67bb83d0641",
"body": null,
"is_bot": false,
"headline": "Add CLAUDE.md and claude bot into workflows",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-15T11:10:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5b6fdc6d33962ef989b5a752af097968100210b8",
"body": "…LE, and FORMAT clauses (#182)\n\n---------\n\nCo-authored-by: Copilot <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Enhance SHOW DATABASES statement to support LIKE, ILIKE, LIMIT, OUTFI…",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-08-12T10:26:44Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "17e786410300307200857501a6ba82d963b053f9",
"body": "Co-authored-by: Copilot <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>",
"is_bot": false,
"headline": "Add support for SHOW and DESC/DESCRIBE statements (#180)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-08-12T03:18:58Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "4f49fc62596fc4ccf5ee66038cef0c9ff4c2ce5a",
"body": null,
"is_bot": false,
"headline": "Update README",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-11T09:05:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4e4cfbf618186f4c42c13b5f4b3355ebe4c4b7fc",
"body": null,
"is_bot": false,
"headline": "Add support of AST travering by the Walk function",
"author_name": "git-hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-11T09:01:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3cdc4c1e8e114c77c8b6d88298ebdc2a40b98069",
"body": null,
"is_bot": false,
"headline": "Add support of PROJECTION column in CREATE TABLE (#178)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-08-01T06:31:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b84b7e1c1b5d3425328bb26decaef773be8db5aa",
"body": "---------\n\nCo-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>\nCo-authored-by: git-hulk <4987594+git-hulk@users.noreply.github.com>\nCo-authored-by: git-hulk <hulk.website@gmail.com>",
"is_bot": false,
"headline": "Add support for CREATE DICTIONARY statement (#175)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-07-17T14:16:26Z",
"body_truncated": false,
"is_coding_agent": true
},
{
"oid": "6aaddc066e96bf9909e557d0e5842e2dc92a3e68",
"body": null,
"is_bot": false,
"headline": "Remove an extra leading space when formatting the WINDOW FUNCTION (#174)",
"author_name": "hulk",
"author_login": "git-hulk",
"committed_at": "2025-07-11T03:10:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "91718f80fa2fcffb2dfd5b019c526cf42a78faf4",
"body": null,
"is_bot": false,
"headline": "Fix positions of Window Clause and string generation (#173)",
"author_name": "Andrei Kochemirovskii",
"author_login": "Blackmorse",
"committed_at": "2025-07-11T02:08:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "21fc5f072970bca68c2e293e42a454aa754658c4",
"body": "…umentation (#170)\n\nCo-authored-by: git-hulk <hulk.website@gmail.com>",
"is_bot": false,
"headline": "Add support for CREATE USER statement according to ClickHouse SQL doc…",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-07-03T09:07:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bce7652f34aceac291f6ead7c65f47788247bdde",
"body": null,
"is_bot": false,
"headline": "Export Enter and Leave methods in ASTVisitor interface (#172)",
"author_name": "Copilot",
"author_login": "Copilot",
"committed_at": "2025-07-03T07:47:35Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 24,
"commits_last_year": 95,
"latest_release_at": "2026-07-11T07:11:11Z",
"latest_release_tag": "v0.5.2",
"releases_from_tags": false,
"days_since_last_push": 16,
"active_weeks_last_year": 29,
"days_since_latest_release": 16,
"mean_days_between_releases": 35.3
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": false,
"health_percentage": 37,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "github.com/AfterShip/clickhouse-sql-parser",
"exists": true,
"license": null,
"keywords": [],
"ecosystem": "go",
"matches_repo": true,
"registry_url": "https://pkg.go.dev/github.com/AfterShip/clickhouse-sql-parser",
"is_deprecated": false,
"latest_version": "v0.5.2",
"repository_url": "https://github.com/AfterShip/clickhouse-sql-parser",
"versions_count": 33,
"total_downloads": null,
"dependents_count": null,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": null,
"first_published_at": null,
"latest_published_at": "2026-07-05T07:23:50Z",
"latest_version_yanked": null,
"days_since_latest_publish": 22
}
]
},
"popularity": {
"forks": 51,
"stars": 242,
"watchers": 5,
"fork_history": {
"days": [
{
"date": "2023-09-22",
"count": 2
},
{
"date": "2023-09-24",
"count": 1
},
{
"date": "2023-10-18",
"count": 1
},
{
"date": "2024-01-22",
"count": 1
},
{
"date": "2024-01-26",
"count": 1
},
{
"date": "2024-02-08",
"count": 1
},
{
"date": "2024-06-09",
"count": 1
},
{
"date": "2024-06-11",
"count": 1
},
{
"date": "2024-06-14",
"count": 1
},
{
"date": "2024-07-09",
"count": 1
},
{
"date": "2024-07-15",
"count": 1
},
{
"date": "2024-07-18",
"count": 1
},
{
"date": "2024-08-06",
"count": 1
},
{
"date": "2024-09-27",
"count": 1
},
{
"date": "2024-11-06",
"count": 1
},
{
"date": "2024-11-28",
"count": 1
},
{
"date": "2024-12-27",
"count": 1
},
{
"date": "2025-02-10",
"count": 1
},
{
"date": "2025-02-26",
"count": 1
},
{
"date": "2025-03-21",
"count": 1
},
{
"date": "2025-04-05",
"count": 1
},
{
"date": "2025-04-24",
"count": 1
},
{
"date": "2025-05-23",
"count": 1
},
{
"date": "2025-05-29",
"count": 1
},
{
"date": "2025-06-07",
"count": 1
},
{
"date": "2025-06-11",
"count": 1
},
{
"date": "2025-06-18",
"count": 1
},
{
"date": "2025-07-07",
"count": 1
},
{
"date": "2025-07-14",
"count": 1
},
{
"date": "2025-07-18",
"count": 1
},
{
"date": "2025-07-22",
"count": 1
},
{
"date": "2025-08-12",
"count": 1
},
{
"date": "2025-08-16",
"count": 1
},
{
"date": "2025-08-21",
"count": 1
},
{
"date": "2025-09-25",
"count": 1
},
{
"date": "2025-09-30",
"count": 1
},
{
"date": "2025-10-02",
"count": 1
},
{
"date": "2025-10-11",
"count": 1
},
{
"date": "2025-10-26",
"count": 1
},
{
"date": "2025-11-03",
"count": 1
},
{
"date": "2025-11-07",
"count": 1
},
{
"date": "2025-11-17",
"count": 2
},
{
"date": "2025-11-25",
"count": 1
},
{
"date": "2026-01-12",
"count": 1
},
{
"date": "2026-01-20",
"count": 1
},
{
"date": "2026-01-28",
"count": 1
},
{
"date": "2026-03-18",
"count": 1
},
{
"date": "2026-04-08",
"count": 1
},
{
"date": "2026-05-11",
"count": 1
}
],
"complete": true,
"collected": 51,
"total_forks": 51
},
"star_history": null,
"open_issues_and_prs": 0
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [
"Makefile"
],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [
"go.mod"
],
"largest_source_bytes": 123155,
"source_files_sampled": 32,
"oversized_source_files": 3,
"agent_instruction_files": [
"AGENTS.md"
],
"agent_instruction_max_bytes": 3523
},
"dependencies": {
"manifests": [
"go.mod"
],
"advisories": {
"error": null,
"scope": "repository_graph",
"source": "osv",
"findings": [],
"collected": true,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 6,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [
"go"
],
"dependencies": [
{
"name": "github.com/sebdah/goldie/v2",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v2.5.3"
},
{
"name": "github.com/stretchr/testify",
"manifest": "go.mod",
"ecosystem": "go",
"version_constraint": "v1.8.4"
}
],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "github.com/sebdah/goldie/v2",
"direct": true,
"version": "v2.5.3",
"ecosystem": "go"
},
{
"name": "github.com/stretchr/testify",
"direct": true,
"version": "v1.8.4",
"ecosystem": "go"
},
{
"name": "github.com/davecgh/go-spew",
"direct": false,
"version": "v1.1.1",
"ecosystem": "go"
},
{
"name": "github.com/pmezard/go-difflib",
"direct": false,
"version": "v1.0.0",
"ecosystem": "go"
},
{
"name": "github.com/sergi/go-diff",
"direct": false,
"version": "v1.0.0",
"ecosystem": "go"
},
{
"name": "gopkg.in/yaml.v3",
"direct": false,
"version": "v3.0.1",
"ecosystem": "go"
}
],
"collected": true,
"truncated": false,
"total_count": 6,
"direct_count": 2,
"indirect_count": 4
}
},
"maintainership": {
"issues": {
"open_prs": 0,
"merged_prs": 182,
"open_issues": 0,
"closed_ratio": 1,
"closed_issues": 87,
"closed_unmerged_prs": 12
},
"bus_factor": 1,
"bot_contributors": 1,
"top_contributors": [
{
"type": "User",
"login": "git-hulk",
"commits": 133,
"avatar_url": "https://avatars.githubusercontent.com/u/4987594?v=4"
},
{
"type": "User",
"login": "sharadgaur",
"commits": 11,
"avatar_url": "https://avatars.githubusercontent.com/u/2407900?v=4"
},
{
"type": "User",
"login": "Lance726",
"commits": 9,
"avatar_url": "https://avatars.githubusercontent.com/u/107540329?v=4"
},
{
"type": "User",
"login": "erezrokah",
"commits": 8,
"avatar_url": "https://avatars.githubusercontent.com/u/26760571?v=4"
},
{
"type": "User",
"login": "laojianzi",
"commits": 7,
"avatar_url": "https://avatars.githubusercontent.com/u/42930263?v=4"
},
{
"type": "User",
"login": "ajruckman",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/40143425?v=4"
},
{
"type": "User",
"login": "rhino1998",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/9094640?v=4"
},
{
"type": "User",
"login": "swgillespie",
"commits": 3,
"avatar_url": "https://avatars.githubusercontent.com/u/1871912?v=4"
},
{
"type": "User",
"login": "hermanschaaf",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/1121616?v=4"
},
{
"type": "User",
"login": "orian",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/144554?v=4"
}
],
"contributors_sampled": 31,
"top_contributor_share": 0.639
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"ci.yaml"
],
"has_docs_dir": false,
"linter_configs": [
".golangci.yml"
],
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [
"go.sum"
],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": null,
"reason": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 10,
"reason": "23 out of 23 merged PRs checked by a CI test -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 5,
"reason": "Found 15/30 approved changesets -- score normalized to 5",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 8 contributing companies or organizations",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 10,
"reason": "no dangerous workflow patterns detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 10,
"reason": "17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": null,
"reason": "packaging workflow not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": 0,
"reason": "dependency not pinned by hash detected -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 5,
"reason": "SAST tool is not run on all commits -- score normalized to 5",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 0,
"reason": "security policy file not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": null,
"reason": "no releases found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": 10,
"reason": "GitHub workflow tokens follow principle of least privilege",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "e4c6e11fcec9a7140ef53835fae0728b2f304a3c",
"ran_at": "2026-07-27T17:24:00Z",
"aggregate_score": 6.3,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": false
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": "2026-07-25T18:53:57Z",
"oldest_open_prs": [],
"last_merged_pr_at": "2026-07-05T07:23:50Z",
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/AfterShip/clickhouse-sql-parser",
"host": "github.com",
"name": "clickhouse-sql-parser",
"owner": "AfterShip"
},
"metrics": {
"overall": {
"key": "overall",
"band": "excellent",
"name": "Overall health",
"note": "The weighted overall 72 is calibrated to 86 on the published index scale (record calibration 2026-08-02).",
"notes": [
{
"code": "overall_calibration",
"params": {
"raw": 72,
"calibrated": 86,
"calibration": "2026-08-02"
}
}
],
"value": 86,
"inputs": {
"security": 70,
"vitality": 86,
"community": 53,
"governance": 72,
"calibration": "2026-08-02",
"engineering": 74,
"ai_readiness": 85,
"weighted_overall_raw": 72
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "excellent",
"name": "Vitality",
"value": 86,
"weight": 0.21,
"metrics": [
{
"key": "development_activity",
"band": "good",
"name": "Development activity",
"note": null,
"notes": [],
"value": 77,
"inputs": {
"commits_last_year": 95,
"human_commit_share": 1,
"days_since_last_push": 16,
"active_weeks_last_year": 29
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 16 days ago",
"points": 28.8,
"status": "partial",
"details": [
{
"code": "push_recency",
"params": {
"days": 16
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "29/52 weeks with commits",
"points": 20.1,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 29
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "95 commits in the last year",
"points": 17.8,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 95
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "exceptional",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 100,
"inputs": {
"releases_count": 24,
"latest_release_tag": "v0.5.2",
"releases_from_tags": false,
"days_since_latest_release": 16,
"mean_days_between_releases": 35.3
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "24 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 24
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 16 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 16
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~35.3 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 35.3
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "exceptional",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "maintained",
"guards": [],
"signals": [],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": null,
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": 28,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 28 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 28
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "moderate",
"name": "Community & Adoption",
"value": 53,
"weight": 0.17,
"metrics": [
{
"key": "popularity",
"band": "moderate",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 56,
"inputs": {
"forks": 51,
"stars": 242,
"watchers": 5,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "242 stars",
"points": 38.6,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 242
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "51 forks",
"points": 14.2,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 51
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "5 watchers",
"points": 3.3,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 5
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "moderate",
"name": "Community health",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"has_readme": true,
"has_license": true,
"readme_badges": null,
"has_contributing": false,
"has_issue_template": false,
"has_code_of_conduct": false,
"readme_badge_services": [],
"has_pull_request_template": false
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (MIT)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "MIT"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "code_of_conduct",
"name": "Code of conduct",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 13.5
},
{
"key": "issue_template",
"name": "Issue template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.2
},
{
"key": "pr_template",
"name": "PR template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.3
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "good",
"name": "Sustainability & Governance",
"value": 72,
"weight": 0.23,
"metrics": [
{
"key": "maintainer_resilience",
"band": "weak",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 41,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 31,
"top_contributor_share": 0.639
},
"components": [
{
"key": "bus_factor",
"name": "Bus factor",
"detail": "1 contributor(s) cover half of all commits",
"points": 9,
"status": "partial",
"details": [
{
"code": "bus_factor",
"params": {
"count": 1
}
}
],
"max_points": 54
},
{
"key": "commit_distribution",
"name": "Commit distribution",
"detail": "top contributor authored 64% of commits",
"points": 8.1,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 64
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "31 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 31
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 8 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "excellent",
"name": "Issue & PR responsiveness",
"note": "Excluded from scoring (no data or not applicable): Newcomer PR acceptance. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"newcomer_pr_acceptance"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 89,
"inputs": {
"merged_prs": 182,
"open_issues": 0,
"closed_issues": 87,
"prs_merged_7d": null,
"prs_decided_7d": null,
"prs_merged_30d": null,
"prs_decided_30d": null,
"issue_closed_ratio": 1,
"closed_unmerged_prs": 12,
"first_time_authors_30d": null,
"first_time_prs_merged_30d": null,
"first_time_prs_decided_30d": null
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "100% of issues closed",
"points": 42,
"status": "met",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 100
}
}
],
"max_points": 42
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "182/194 decided PRs merged",
"points": 28.1,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 182,
"decided": 194
}
}
],
"max_points": 30
},
{
"key": "newcomer_pr_acceptance",
"name": "Newcomer PR acceptance",
"detail": "no first-time contributor's PR decided in 30d",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_newcomer_prs",
"params": {
"days": 30
}
}
],
"max_points": 13
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 15/30 approved changesets -- score normalized to 5",
"points": 7.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 71,
"inputs": {
"followers": 169,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "AfterShip",
"public_repos": 81,
"account_age_days": 5306
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "169 followers of AfterShip",
"points": 16,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 169,
"login": "AfterShip"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "81 public repos, account ~14 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 81
}
},
{
"code": "account_age_years",
"params": {
"years": 14
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "exceptional",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"github.com/AfterShip/clickhouse-sql-parser"
],
"ecosystems": "go",
"any_deprecated": false,
"min_days_since_publish": 22
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on go",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "go"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 22 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 22
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "33 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 33
}
}
],
"max_points": 20
},
{
"key": "not_deprecated",
"name": "Not deprecated",
"detail": "active, not deprecated or yanked",
"points": 20,
"status": "met",
"details": [
{
"code": "package_not_deprecated",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "good",
"name": "Engineering Quality",
"value": 74,
"weight": 0.19,
"metrics": [
{
"key": "engineering_practices",
"band": "excellent",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 84,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": true,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "1 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 1
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": ".golangci.yml",
"points": 16,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": ".golangci.yml"
}
}
],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "23 out of 23 merged PRs checked by a CI test -- score normalized to 10",
"points": 20,
"status": "met",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 60,
"inputs": {
"topics": [
"clickhouse",
"go",
"sql-parser"
],
"has_wiki": true,
"homepage": null,
"has_readme": true,
"has_docs_dir": false,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "repository_description",
"name": "Repository description",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": "3 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 3
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "good",
"name": "Security",
"value": 70,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "moderate",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"branch_protection",
"packaging",
"signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 63,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 15,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 3,
"scorecard_aggregate": 6.3
},
"components": [
{
"key": "binary_artifacts",
"name": "Binary-Artifacts",
"detail": "no binaries found in the repo",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "branch_protection",
"name": "Branch-Protection",
"detail": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "23 out of 23 merged PRs checked by a CI test -- score normalized to 10",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 15/30 approved changesets -- score normalized to 5",
"points": 3.8,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 8 contributing companies or organizations",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no dangerous workflow patterns detected",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "17 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 5",
"points": 2.5,
"status": "partial",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file not detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "GitHub workflow tokens follow principle of least privilege",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "dependency_advisories",
"band": "exceptional",
"name": "Dependency advisories",
"note": "Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 6 resolved dependencies against OSV. This repository publishes no package the index resolves, so the repository dependency graph was assessed instead. That graph mixes development and test pins with shipped dependencies, so only the declared runtime dependencies are scored; transitive findings are reported as context and excluded from the score. Reachability is not analyzed.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"indirect_dependencies_free_of_known_advisories",
"no_advisories_left_outstanding"
]
}
},
{
"code": "weights_renormalized",
"params": {}
},
{
"code": "advisories_scope_repository",
"params": {
"assessed": 6
}
},
{
"code": "advisories_repo_graph_caveat",
"params": {}
},
{
"code": "advisories_reachability",
"params": {}
}
],
"value": 100,
"inputs": {
"source": "osv",
"advisories": 0,
"affected_packages": 0,
"assessed_packages": 6,
"unassessed_packages": 0,
"affected_by_severity": "none",
"direct_affected_packages": 0
},
"components": [
{
"key": "direct_dependencies_free_of_known_advisories",
"name": "Direct dependencies free of known advisories",
"detail": "no direct dependency carries a known advisory",
"points": 35,
"status": "met",
"details": [
{
"code": "no_direct_advisories",
"params": {}
}
],
"max_points": 35
},
{
"key": "indirect_dependencies_free_of_known_advisories",
"name": "Indirect dependencies free of known advisories",
"detail": "transitive set not separable from development and test dependencies in this scope",
"points": 0,
"status": "excluded",
"details": [
{
"code": "advisories_scope_not_separable",
"params": {}
}
],
"max_points": 25
},
{
"key": "no_advisories_left_outstanding",
"name": "No advisories left outstanding",
"detail": "no advisory carries a publication date",
"points": 0,
"status": "excluded",
"details": [
{
"code": "advisories_no_publication_date",
"params": {}
}
],
"max_points": 40
}
]
},
{
"key": "malicious_dependencies",
"band": "exceptional",
"name": "Malicious dependencies",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"source": "osv",
"meaning": "reported as a malicious package by the OpenSSF corpus; the remedy is removal or moving off the compromised name, never an upgrade of the same artifact. Versions the registry has since pulled are listed but not scored",
"packages": [],
"red_flag": false,
"assessed_packages": 6,
"malicious_packages": 0,
"direct_malicious_packages": 0,
"withdrawn_malicious_packages": 0,
"installable_malicious_packages": 0
},
"components": [
{
"key": "no_dependency_reported_as_a_malicious_package",
"name": "No dependency reported as a malicious package",
"detail": "no dependency is reported as a malicious package",
"points": 100,
"status": "met",
"details": [
{
"code": "no_malicious_dependencies",
"params": {}
}
],
"max_points": 100
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "exceptional",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"commit_weight_rule": {
"min_commits": 50,
"min_commit_share": 0.1
},
"review_only_matches": 0,
"below_threshold_exposures": [],
"assessed_self_published_locations": 13
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "excellent",
"name": "AI Readiness",
"value": 85,
"weight": 0.04,
"metrics": [
{
"key": "ai_agent_context",
"band": "excellent",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 85,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.78,
"agent_instruction_files": [
"AGENTS.md"
],
"agent_instruction_max_bytes": 3523
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "AGENTS.md",
"points": 45,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "AGENTS.md"
}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "78 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 40,
"status": "met",
"details": [
{
"code": "legible_history",
"params": {
"legible": 78,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "excellent",
"name": "Verify loop (build / test / typecheck)",
"note": null,
"notes": [],
"value": 82,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [
"go.sum"
],
"has_dockerfile": false,
"typed_language": true,
"bootstrap_files": [
"Makefile"
],
"has_devcontainer": false,
"has_linter_config": true,
"typecheck_configs": [],
"agent_commit_share": 0.25,
"toolchain_manifests": [
"go.mod"
],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": "Makefile",
"points": 18,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Makefile"
}
}
],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": ".golangci.yml",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": ".golangci.yml"
}
}
],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": "Go (statically typed)",
"points": 11,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "Go"
}
}
],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": "lockfile",
"points": 10,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "lockfile"
}
}
],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "25 of the last 100 commits agent-authored or agent-credited",
"points": 10,
"status": "met",
"details": [
{
"code": "agent_authored_commits",
"params": {
"count": 25,
"sampled": 100
}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "no automated dependency updates observed",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_dependency_automation",
"params": {}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "dependency not pinned by hash detected -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "exceptional",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 95,
"inputs": {
"primary_language": "Go",
"largest_source_bytes": 123155,
"source_files_sampled": 32,
"oversized_source_files": 3
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "Go (statically typed)",
"points": 45,
"status": "met",
"details": [
{
"code": "statically_typed_language",
"params": {
"language": "Go"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "3/32 source files over 60KB",
"points": 49.8,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 32,
"oversized": 3
}
}
],
"max_points": 55
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? Carries a deliberately small weight: agent tooling is a real maintenance signal, but its absence must never gate the top of the scale (calibration saturates at raw 91, so 100/100 remains reachable with AI Readiness at zero)."
}
],
"classification": {
"labels": [
"library"
],
"scores": {
"cli": 2,
"library": 8
},
"primary": "library",
"evidence": [
{
"tier": "distribution",
"label": "library",
"source": "registry:go",
"weight": 6
},
{
"tier": "description",
"label": "cli",
"source": "description:cli",
"weight": 2
},
{
"tier": "description",
"label": "library",
"source": "description:library",
"weight": 2
}
],
"artifacts": [],
"confidence": "medium",
"host_extension": false,
"runs_as_process": false,
"consumed_by_code": true
},
"metrics_version": "2.3.1"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token"
],
"report_type": "repository",
"generated_at": "2026-07-27T17:24:27.075016Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/a/AfterShip/clickhouse-sql-parser.svg",
"full_name": "AfterShip/clickhouse-sql-parser",
"license_state": "standard",
"license_spdx": "MIT"
}
Verwandte Einträge
Geprüfte Repositories, die Katalog-Tags oder Ökosysteme mit AfterShip/clickhouse-sql-parser teilen. Nebeneinander lesen →
Bewertungen sind Signale, keine Garantien. Sie spiegeln öffentlich sichtbare Praxis auf GitHub wider — kein Code-Audit und keine Sicherheitsgarantie.
Fehlende Daten werden ausgeschlossen und die Gewichte neu normiert, nie als null bewertet. Die Methodik ist versioniert und offen: Metriken v2.3.1, Schema v0.27.0 — vollständige Methodik · Metriken-Wiki.
