yukikotani231

Issues somebody may already be working on are listed last. List everything by date

• Add a Supabase example project

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  documentation good first issue

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

  yukikotani231/sqlsift#405 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• Add a Drizzle example project

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  documentation good first issue

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

  yukikotani231/sqlsift#404 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• `sqlsift rules <CODE>`: explain one rule

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#403 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• `--format junit`: JUnit XML report for CI systems

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#402 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• `sqlsift completions <shell>`: shell completion scripts

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#401 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• CLI: `--color auto|always|never`

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#400 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• E0003: LIMIT / OFFSET with a value that isn't an integer (`LIMIT 'ten'`, `LIMIT true`, `LIMIT name`)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#398 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• E0003: type-check BETWEEN bounds and IN list items (`id BETWEEN 'a' AND 'b'`, `id IN ('x')`)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#397 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• E0005: VALUES rows of different lengths (`VALUES (1, 'a'), (2)`)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#396 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• COMMENT ON TABLE / COLUMN: report a missing table or column

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#395 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• TRUNCATE and LOCK TABLE: report missing tables (E0001)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

  Difficulty 3/5 1-2 days Newbie friendliness 83/100

  yukikotani231/sqlsift#394 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• COPY: check the table, its column list, and the query of `COPY (...) TO`

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement good first issue

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

  yukikotani231/sqlsift#393 · Opened Oct 16, 2026

  Maintainers usually reply within 1 day

• core: prove that HashMap and BytesMap lookups find every key the map holds

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  area/library help wanted proofs

  Difficulty 5/5 Over a week Newbie friendliness 34/100

  yukikotani231/bastiolang#283 · Opened Oct 15, 2026

  Maintainers usually reply within 1 day

• Rewrite suggestions the schema proves equivalent (join elimination, redundant DISTINCT, perf fixes)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 30/100

  yukikotani231/sqlsift#357 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Schema-aware rewrites: qualify columns, match identifier spelling to the schema, expand `SELECT *`

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#356 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• `sqlsift docs`: schema documentation with the queries that use each table

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#355 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Warn on queries that use columns or tables marked deprecated in the schema

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 4/5 3-5 days Newbie friendliness 48/100

  yukikotani231/sqlsift#353 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Report which queries read sensitive columns (tagged in the schema or config)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#354 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• `sqlsift impact`: rolling-deploy check (old queries against the new schema, new queries against the old schema)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#352 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Suspicious: sqlc `:one` query that can return more than one row

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 45/100

  yukikotani231/sqlsift#351 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Permission check: queries the application's role has no privilege for (from GRANT statements in the schema)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#346 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• INSERT / UPDATE / DELETE on a view that isn't updatable, or on a materialized view

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  yukikotani231/sqlsift#345 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Editors beyond VS Code: Neovim, JetBrains, Zed, Helix

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

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

  yukikotani231/sqlsift#342 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• SQL Server (T-SQL) and Oracle dialects

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  yukikotani231/sqlsift#340 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• MCP server: let AI agents check SQL against the schema before running it

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#341 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Check SQL in Ruby, Java / Kotlin and PHP code

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#338 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Read the schema from ORM definitions (Rails schema.rb, Django models, TypeORM / Drizzle / Prisma)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 48/100

  yukikotani231/sqlsift#339 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• First `pedantic` and `style` rules

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  yukikotani231/sqlsift#336 · 1 comment · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Custom rules defined by users

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  yukikotani231/sqlsift#337 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Analyze SQL inside function bodies (`LANGUAGE sql`, PL/pgSQL)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#335 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Split `analyzer/resolver.rs` and `schema/builder.rs` into smaller modules

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 4/5 3-5 days Newbie friendliness 51/100

  yukikotani231/sqlsift#331 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• BigQuery (alpha): the project part of a table name is ignored, so `other-project.ds.t` is checked against `ds.t`

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  bug

  Difficulty 4/5 1-2 days Newbie friendliness 58/100

  yukikotani231/sqlsift#332 · 1 comment · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Share the `sqlsift.toml` loader between the CLI and the LSP

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  yukikotani231/sqlsift#330 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• LSP: pick up schema and config changes made outside the editor (new migrations, git checkout, `sqlsift.toml` edits)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 4/5 3-5 days Newbie friendliness 48/100

  yukikotani231/sqlsift#328 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• LSP: multi-root workspaces and `sqlsift.toml` below the workspace root (monorepos)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 45/100

  yukikotani231/sqlsift#329 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• MySQL: E0017 / E0008 / E0004 / E0015 assume MySQL 8.0 defaults and are false positives on non-strict or 5.7-style servers

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  bug rules

  Difficulty 5/5 Over a week Newbie friendliness 38/100

  yukikotani231/sqlsift#325 · Opened Oct 12, 2026

  Maintainers usually reply within 1 day

• Column-level lineage (which source columns each output column comes from)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#300 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• Schema diff and migration generation (compare two catalogs)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 48/100

  yukikotani231/sqlsift#299 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• Split the catalog and resolver into embeddable crates

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  yukikotani231/sqlsift#298 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• Type generation from `sqlsift describe` (TypeScript, Rust, Python) as a separate crate

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#297 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• Migration safety rules: locks and table rewrites in schema changes

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#296 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• `sqlsift describe`: estimated access path per table (index or scan)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#295 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• perf: WHERE / JOIN on unindexed columns of tables marked large

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#293 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• perf: composite index used without its leading column

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#292 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• perf: leading-wildcard LIKE on an indexed column

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  yukikotani231/sqlsift#291 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• perf: implicit type conversion that prevents index use

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 38/100

  yukikotani231/sqlsift#290 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• perf: indexed column wrapped in a function or expression

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 38/100

  yukikotani231/sqlsift#289 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• perf: foreign key column without an index

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 4/5 3-5 days Newbie friendliness 53/100

  yukikotani231/sqlsift#288 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• Record all indexes in the catalog (non-unique, composite, expression, partial)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 5/5 Over a week Newbie friendliness 35/100

  yukikotani231/sqlsift#287 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day

• `perf` rule category: index- and type-aware performance checks

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement rules

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  yukikotani231/sqlsift#286 · Opened Oct 11, 2026

  Maintainers usually reply within 1 day