Curated issues

SQL Good First Issues

Browse open source issues tagged with SQL in the issue metadata. Results stay focused on work that can become public contribution evidence.

SQL

What this list is like

Average annotated difficulty: 3.9/5 across 83,425 issues.
6% of 83,425 time estimates are one day or less.

About SQL

The query language of relational databases (1974), standardised and spoken by MySQL, PostgreSQL, SQLite and most of the rest.

Beginner friendly Everything

Open All

BUG: Adding a folder also re-indexes similarly named sibling folders (unbounded LIKE prefix match in db_get_folder_ids_by_path_prefix) Open

bug possible-duplicate

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

AOSSIE-Org/PictoPy#1553 · 4 comments · Opened Sep 21, 2026
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 90/100

coder/coder#29623 · 1 comment · Opened Sep 20, 2026
v1 manifest list: existing_files_count is the table-wide total-data-files Open

comp-datalake

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

ClickHouse/ClickHouse#121222 · Opened Sep 20, 2026
Translation to Portuguese Open

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

libredb/libredb-studio#1019 · Opened Sep 20, 2026
Back-quotes dropped from a GROUP BY key named `cube`/`rollup` and a CTE named `recursive`: the stored view definition does not parse back and server startup fails Open

comp-sql-syntax minor

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

ClickHouse/ClickHouse#121170 · Opened Sep 20, 2026
COPY ... STDIN/STDOUT (options) fails when `WITH` keyword is omitted Open

comp-sql-syntax

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

ClickHouse/ClickHouse#121150 · Opened Sep 20, 2026
SecureFileStore.readFully() may skip decryption when off > 0 and the destination prefix is zeroed Open

Difficulty 2/5 1-3 hours Newbie friendliness 86/100

h2database/h2database#4405 · Opened Sep 20, 2026
actionlint config comment cites 89 baseline findings; the measured baseline is 97 Open

area/ci kind/documentation

Difficulty 1/5 Under an hour Newbie friendliness 92/100

spiceai/spiceai#14242 · Opened Sep 19, 2026
make signoff fails in librdkafka's configure when the Command Line Tools SDK is newer than Xcode's linker Open

kind/bug

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

spiceai/spiceai#14239 · 1 comment · Opened Sep 19, 2026
Bug: Hardcoded uploadtree_a table and missing boundary guards in UploadController::uploadDownload() Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

fossology/fossology#3844 · Opened Sep 19, 2026
Mark agtype_string_match_starts_with / _ends_with IMMUTABLE (contains already is) Open

Difficulty 1/5 Under an hour Newbie friendliness 88/100

apache/age#2576 · Opened Sep 19, 2026
`ATTACH TABLE t ENGINE = E AS other` formatted as `ATTACH TABLE t AS other ENGINE = E` — parser rejects the formatted form (`AS other` must come after storage for `ATTACH`) Open

comp-sql-syntax fuzz

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

ClickHouse/ClickHouse#121027 · 2 comments · Opened Sep 19, 2026
Formatter emits unquoted identifier `not`: `SELECT NOT \`not\`` re-formats to `SELECT NOT not` which does not parse back Open

comp-sql-syntax fuzz

Difficulty 2/5 1-3 hours Newbie friendliness 85/100

ClickHouse/ClickHouse#121025 · 2 comments · Opened Sep 19, 2026
`clickhouse local` accepts `--logger.level` but always logs at `trace` to the console — user-supplied level is overwritten with `trace` Open

comp-local fuzz

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

ClickHouse/ClickHouse#121022 · 2 comments · Opened Sep 19, 2026
`formatQueryFromJSON`: `ALTER TABLE ... MODIFY CONSTRAINT` without `constraint_decl` — null-pointer dereference in `ASTAlterCommand::formatImpl` Open

comp-sql-syntax fuzz

Difficulty 2/5 1-3 hours Newbie friendliness 86/100

ClickHouse/ClickHouse#121021 · 1 comment · Opened Sep 19, 2026
Consider adding stacked and dodged bar plots Open

Difficulty 2/5 1-3 hours Newbie friendliness 74/100

datacarpentry/semester-biology#1255 · Opened Sep 19, 2026
Two default alert rules in the monitoring sample never stop firing Open

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

cloudnative-pg/cloudnative-pg#11511 · 1 reaction · Opened Sep 19, 2026
OPDS pagination serves some books twice and others never, when books share an addedOn second Open

Difficulty 2/5 1-3 hours Newbie friendliness 76/100

grimmory-tools/grimmory#2701 · Opened Sep 19, 2026
cayenne: a_build_the_pool_cannot_fit_is_not_retried_on_every_lookup asserts a fixed throughput (>100 lookups in 4s), so a busy runner fails it 6/6 and breaks unrelated sign-offs Open

area/cayenne area/ci area/tests kind/bug

Difficulty 2/5 1-3 hours Newbie friendliness 72/100

spiceai/spiceai#14219 · Opened Sep 19, 2026
Proofread README_ja.md: no Japanese speaker has ever reviewed it Open

documentation good first issue hacktoberfest help wanted

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

libredb/libredb-studio#973 · Opened Sep 18, 2026
Docs: how to sample random rows cheaply (ORDER BY RAND() scans the whole table) Open

customer issue documentation enhancement sql

Difficulty 2/5 1-3 hours Newbie friendliness 76/100

dolthub/dolt#11900 · 1 comment · Opened Sep 18, 2026
sigma: unary negation dropped Open

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

apache/ossie#426 · 2 comments · Opened Sep 18, 2026
Remove the 0.16.0 logout note from docs/OIDC.md once a newer image is published Open

documentation good first issue hacktoberfest

Difficulty 2/5 1-3 hours Newbie friendliness 74/100

libredb/libredb-studio#963 · Opened Sep 18, 2026
databricks: case-sensitive cascade-drop leaves metric views referencing dropped fields Open

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

apache/ossie#422 · 1 comment · Opened Sep 18, 2026
assert_cast silently degrades to static_cast in debug/sanitizer builds Open

comp-memory

Difficulty 2/5 1-3 hours Newbie friendliness 82/100

ClickHouse/ClickHouse#120865 · Opened Sep 18, 2026
New stddev/stdvar integration cases pass unchanged without the fix Open

comp-testing

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

ClickHouse/ClickHouse#120855 · Opened Sep 18, 2026
Remove the sqlglot<30.18 dev constraint once ibis fixes duckdb create_table Open

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

posit-dev/orbital#138 · Opened Sep 18, 2026
bug(duckdb): create_table with in-memory data fails with sqlglot>=30.18 (nameless DROP VIEW) Open

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

ibis-project/ibis#12124 · Opened Sep 18, 2026
fix(tui): `publishInFlight` latch blocks publishing a different skill while one uploads Open

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

AltimateAI/altimate-code#1323 · Opened Sep 18, 2026
modulo() throws on constant divisor equal to type's minimum value Open

comp-regular-function

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

ClickHouse/ClickHouse#120810 · Opened Sep 18, 2026
refactor: make reflected table and view name ordering deterministic Open

area: reflection enhancement good first issue help wanted size: XS

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

cubrid-lab/sqlalchemy-cubrid#443 · Opened Sep 18, 2026
fix: timezone-aware type instances should preserve timezone=True Open

area: type compiler bug good first issue help wanted size: S

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

cubrid-lab/sqlalchemy-cubrid#442 · 1 comment · Opened Sep 18, 2026
fix: do not treat explicit zero VARCHAR length as unspecified Open

area: compiler bug good first issue help wanted size: S

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

cubrid-lab/sqlalchemy-cubrid#440 · Opened Sep 18, 2026
fix: include REPLACE in autocommit-text detection Open

area: dialect bug good first issue help wanted size: XS

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

cubrid-lab/sqlalchemy-cubrid#439 · Opened Sep 18, 2026
Redshift: statement_timeout SET uses Postgres interval syntax, so every query fails at connection setup Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

dbt-labs/dbt-charts#39 · Opened Sep 18, 2026
duration-parse panics on a non-ASCII character where it expects a number, so runtime.query.timeout: 30秒 crashes startup instead of warning Open

kind/bug

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

spiceai/spiceai#14202 · Opened Sep 18, 2026
Query "incorrecta" se da por buena Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

midudev/aprendesql.dev-issues#107 · Opened Sep 18, 2026
Improper Input Validation in Snowflake CLI Versions Allow Unsanitized User-Controlled Values to be Interpolated into SQL Strings Open

1.severity: security

Difficulty 2/5 1-3 hours Newbie friendliness 72/100

NixOS/nixpkgs#564505 · Opened Sep 18, 2026
Partitions page: "same data and number of rows" claim is contradicted by the live playground (tables hold different dataset snapshots) Open

comp-documentation external

Difficulty 2/5 1-3 hours Newbie friendliness 74/100

ClickHouse/ClickHouse#120755 · Opened Sep 18, 2026
`formatQueryFromJSON`: `SYSTEM` commands with a mandatory table accepted without `table` — `chassert(table)` in `ASTSystemQuery::formatImpl` Open

comp-sql-syntax fuzz

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

ClickHouse/ClickHouse#120739 · 5 comments · Opened Sep 18, 2026
`formatQueryFromJSON`: standalone `TableOverride` with empty `table_name` asserts / renders unparsable SQL Open

comp-sql-syntax fuzz

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

ClickHouse/ClickHouse#120737 · 3 comments · Opened Sep 18, 2026
[YSQL] yb_explain_hide_non_deterministic_fields does not hide per worker sort memory Open

area/ysql kind/bug priority/medium

Difficulty 2/5 1-3 hours Newbie friendliness 82/100

yugabyte/yugabyte-db#34023 · Opened Sep 17, 2026
[YSQL] TestPgRegressMergeScan: auto analyze races the expression index, and the suite pins the unanalyzed state Open

area/ysql kind/failing-test priority/medium status/awaiting-triage

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

yugabyte/yugabyte-db#34021 · Opened Sep 17, 2026
Oracle: _json filters and json() return quoted strings, silently breaking every string comparison Open

Bug Engine

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

directus/directus#28256 · 1 comment · Opened Sep 17, 2026
AGENTS.md with instructions for scanning for common security problems Open

documentation

Difficulty 2/5 1-3 hours Newbie friendliness 72/100

simonw/datasette#2940 · Opened Sep 17, 2026
Mute ydb/core/http_proxy/ut/inside_ydb_ut/TestYmqHttpProxy.TestDeleteMessage in main Open

ai_reviewed

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

ydb-platform/ydb#53431 · 3 comments · Opened Sep 17, 2026
Our implementation of the year function on Oracle is using the wrong date standard Open

Bug Engine Integrations Med Impact Med Reach Oracle

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

directus/directus#28254 · 1 comment · Opened Sep 17, 2026
Migration 0255 drops tool_connections_transport_check without IF EXISTS, breaking upgrade to 2026.916.0 Open

Difficulty 1/5 Under an hour Newbie friendliness 92/100

paperclipai/paperclip#13577 · Opened Sep 17, 2026

Showing the newest 100

This page lists what was indexed most recently. Advanced filter has the whole inventory, narrowed by language, difficulty and how long a task takes.

Open advanced filter

SQL Good First Issues

What this list is like

About SQL

Showing the newest 100

Get new issues in your inbox