# sqlancer/sqlancer

Automated testing to find logic and performance bugs in database systems

Repository: https://github.com/sqlancer/sqlancer
Canonical: https://ross.abutalabs.com/products/sqlancer
Homepage: http://www.sqlancer.com/
Language: Java
License: MIT
License Family: permissive
Topics: testing, sql, dbms, fuzzing, dbms-testing, sqlite, mysql, postgresql, mariadb, tidb, cockroachdb
Last push: 2026-08-24T05:14:26+00:00

## Health v2 (maintenance only)
Score: 67/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 8, longevity 100
- inputs: {"age_days": 2343, "days_push": 9, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1750, forks 398 (observed 2026-08-28T04:05:31.055412+00:00)

## What it is
SQLancer is a Java-based automated testing tool that finds logic and performance bugs in database management systems. It generates SQL test inputs and applies test oracles such as Ternary Logic Partitioning, NoREC, and Pivoted Query Synthesis to detect incorrect results, crashes, and performance issues.

## Use cases
- find logic bugs in a database system
- fuzz test sqlite mysql postgresql
- detect incorrect query results in a dbms
- find performance bugs in query optimizers
- automated testing of cockroachdb or tidb
- discover crash bugs in database implementations

## When to choose
- you develop or maintain a DBMS and want automated bug finding
- you want to validate query correctness with published test oracles
- you need to stress-test SQL implementations across many database engines

## When to avoid
- you want to test your own SQL queries rather than the DBMS itself
- you need functional/load testing of an application's database usage
- you need a general-purpose web or API fuzzer

## Facets
- artifact type: cli-tool
- maturity: active
- function: testing, fuzzing
- domain: databases, testing, developer-tools
- platform: cli, jvm, cross-platform
- tags: sql, dbms-testing, test-oracles, logic-bugs, java

## Member repositories
- sqlancer/sqlancer (main) score 67

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:31.055412+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:28:45.634309+00:00, confidence not recorded.
  - readme: https://github.com/sqlancer/sqlancer (fetched 2026-08-28T04:05:31.055412+00:00, sha 52ed98291e61)
- Data as of 2026-08-30T08:39:29.467469+00:00.