Ross ROSS = Recommend OSS · open-source software intelligence for agents

tobymao/sqlglot

Python SQL Parser and Transpiler observed · 2026-08-28

github.com/tobymao/sqlglot · homepage · Python · MIT (permissive) observed · 2026-08-28

Health v2 · maintenance only

77/100

  • Activity 99
  • Release rhythm 35
  • Longevity 100

Flags: no_releases

How is this computed?

round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.

  • gap_med: n/a
  • age_days: 1999
  • days_rel: n/a
  • days_push: 7
  • n_releases_24m: 0

Full methodology

Adoption not part of the score

9569 stars · 1263 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

SQLGlot is a dependency-free Python SQL parser, transpiler, optimizer, and execution engine supporting 30+ SQL dialects such as DuckDB, Snowflake, BigQuery, and Spark. It enables formatting, translating, analyzing, and programmatically building SQL via expression trees.

Use cases

  • translate SQL between dialects like Snowflake and BigQuery
  • format and pretty-print SQL queries
  • parse SQL into an AST for analysis
  • detect SQL syntax errors and dialect incompatibilities
  • programmatically build or modify SQL queries
  • optimize SQL queries
  • execute SQL with a pure-Python engine

When to choose

  • you need dialect-agnostic SQL parsing or translation in Python
  • you want a zero-dependency, pure-Python SQL tool
  • you need to analyze, lint, or rewrite SQL programmatically

When to avoid

  • you need a full production database engine rather than parsing/transpiling
  • you need a non-Python runtime

Facets

library · maturity stable

parser compiler developer-tools databases parsers developer-tools python cross-platform sql transpiler sql-dialects ast query-optimization sql-formatting query-engine data-engineering

2 sources

Member repositories

RepositoryRoleHealth v2
tobymao/sqlglotmain77

For agents

markdown · JSON · MCP: product_card(name="tobymao/sqlglot")

Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem