Built something? We create video reels & spotlights for GitHub projects.Promote your project →
tobymao
Home / Python / sqlglot

tobymao/sqlglot

Python SQL Parser and Transpiler

Python ◇ bigquery MIT
★9.6KSTARS
⑂1.3KFORKS
!12ISSUES
🏆#704GLOBAL RANK
🔥4DAYS TRENDING
🚀
Maintainer Growth Kit for sqlglot

Claim this project, add your verified backlink badge to your README, and download milestone cards.

Claim Repo

Star History

Continuous Observations
Interactive star growth chart for tobymao/sqlglot
CSV

Momentum

+241

STARS · LAST 30 DAYS

8

PER DAY

#122

MOST-STARRED Python

Window7 days30 days90 days
Stars gained+56+241+720
Per day888
Forks gained+7+26+65

sqlglot gained 241 stars in the last 30 days, about 8 a day, and now has 9.6K. It is about 6 years old and has averaged roughly 1.6K stars a year. It ranks #122 among Python repositories and #704 across all languages on GitHubRepo.

Trending Record

sqlglot has maintained a continuous presence across global trending indexes, peaking at #839. Below is the 30-day activity profile:

💡 Overview

sqlglot is an open-source project written in Python: Python SQL Parser and Transpiler.

Engineered for speed, consistency, and developer ease, it solves common hurdles in bigquery, clickhouse, databricks. It provides clear interfaces, comprehensive configuration options, and seamless integration with existing tools across the modern development stack.

⚡ Key Features

1

Optimized execution pipeline written in Python for predictable speed.

2

Zero-friction configuration with comprehensive sensible defaults out of the box.

3

Cross-platform runtime support across Linux, macOS, and Windows environments.

4

Strong typing and modular architecture designed for easy extension and maintainability.

5

Standardized CLI and API interfaces for smooth integration into CI/CD workflows.

6

Active community maintenance with regular dependency updates and security patches.

📥 Installation

terminal
$ pip install sqlglot

⚙ System Requirements

Platforms

  • • macOS
  • • Linux
  • • Windows

Runtime & Dependencies

Python >= 3.9, pip, virtualenv

Architecture

x86_64, ARM64 (Apple Silicon & Graviton)

🧠 How It Works

sqlglot coordinates its core functionality through a modular Python pipeline. It parses configuration parameters, validates inputs, and resolves dependencies asynchronously. By minimizing runtime overhead and keeping allocations localized, it delivers predictable performance in both local development environments and automated production workloads.

🎯 Production Use Cases

Command-Line Automation

Execute automated build, deployment, and maintenance tasks directly from the terminal.

CI/CD Workflow Integration

Run non-interactive validation checks in GitHub Actions, GitLab CI, or local pre-commit hooks.

Developer Environment Setup

Standardize local engineering workstations with single-binary utility commands.

Scripting & Pipeline Orchestration

Chain complex multi-stage scripts with reliable error reporting and exits.

🚀 Getting Started

1

Install sqlglot using your package manager: `pip install sqlglot`

2

Initialize your project workspace or configuration file for sqlglot.

3

Import sqlglot into your codebase or invoke it directly from your terminal.

4

Execute your test suite or run `sqlglot --help` to verify successful setup.

👍 Strengths

Active community backing with 9,638 GitHub stars and verified adoption.
Permissive open-source distribution under the MIT license.
Built in Python for high execution speed and developer familiarity.
Cross-platform compatibility across modern Linux, macOS, and Windows environments.
Clean modular design allowing flexible configuration and pipeline integration.

⚠️ Considerations

Requires familiarity with Python and modern CLI workflows.
Ecosystem extensions may require manual configuration depending on environment constraints.
Active development roadmap means breaking API changes may occur across major versions.

⇄ Alternatives & Direct Competitors

P
public-apis/public-apis ★ 483.8K Python

A collective list of free APIs

Compare ↗
F

:books: Freely available programming books

Compare ↗
P

Curated list of project-based tutorials

Compare ↗
H
NousResearch/hermes-agent ★ 249.8K Python

The agent that grows with you

Compare ↗

👥 Who Should Use This

Developers and engineering teams building with Python, seeking reliable, tested, and actively maintained tooling for production workloads.

🏆 Nearby in the Rankings

tobymao/sqlglot is currently ranked #704 by stars across every repository tracked on GitHubRepo. These are adjacent projects:

RankRepositoryLanguageStarsAction
#699 NVIDIA/cudf C++ ★ 9.8K Compare ↗
#700 activeadmin/activeadmin Ruby ★ 9.7K Compare ↗
#701 doctrine/dbal PHP ★ 9.7K Compare ↗
#701 ashishb/android-security-awesome Makefile ★ 9.7K Compare ↗
#703 kyutai-labs/pocket-tts Python ★ 9.7K Compare ↗
#704 tobymao/sqlglot This Project Python ★ 9.6K
#704 Vincentwei1021/video-shotcraft TypeScript ★ 9.6K Compare ↗
#706 reviewdog/reviewdog Go ★ 9.6K Compare ↗
#707 anchore/syft Go ★ 9.6K Compare ↗
#708 roboflow/rf-detr Python ★ 9.6K Compare ↗
#709 v2fly/domain-list-community Go ★ 9.6K Compare ↗

Frequently Asked Questions

What does sqlglot do? +

Python SQL Parser and Transpiler

What language is sqlglot written in? +

The primary language is Python. Topics include: bigquery, clickhouse, databricks, duckdb, hive.

Is sqlglot actively maintained? +

Yes, the last recorded push was on Sep 26, 2026 with 12 open issues being tracked.

How many stars does sqlglot have? +

sqlglot has 9,639 stars and 1,301 forks on GitHub.

How does sqlglot rank among GitHub repositories? +

With 9,639 stars, tobymao/sqlglot is ranked #704 globally across all repositories tracked on GitHubRepo and #122 among Python projects.

What license is sqlglot distributed under? +

The repository reports a MIT license. Always verify the repository LICENSE file for legal terms.

From our network
FOR MAINTAINERS

Built something? Put it in front of millions of developers.

We make a short reel about your project and post it across YouTube, Instagram, Threads, and X. Send a link, we do the rest.