跳到正文
DEV Community· Ashish sinha·· 2 小時前AI 評分45

開源 Text-to-SQL 程式庫 schemagate 在 BIRD Mini-Dev 三種 SQL 方言評測中均排名第一

My open-source text-to-SQL layer is #1 on BIRD Mini-Dev in all three dialects

AI 導讀

開源程式庫 schemagate 在 BIRD Mini-Dev 的 SQLite、PostgreSQL 和 MySQL 評測中均排名第一,分數分別為 81.0、72.6 和 72.4。它會先篩選問題所需資料表,再由 Claude Opus 5.5 編寫查詢;程式庫的主要用途是存取控制。這項結果不代表它在使用隱藏測試集的 BIRD 主排行榜上排名第一。

正文

Cover image for My open-source text-to-SQL layer is #1 on BIRD Mini-Dev in all three dialects

Ashish sinha

BIRD Mini-Dev is 500 text-to-SQL questions over 11 databases, in SQLite, PostgreSQL and MySQL versions, scored by whether the query returns the right rows. BIRD keeps the leaderboard and checks the submissions.

schemagate, the Apache-2.0 library I maintain, is now first in all three columns:

schemagate Next entry
SQLite 81.0 75.6
PostgreSQL 72.6 69.0
MySQL 72.4 49.2

The setup is plain: schemagate picks the tables a question needs, the prompt carries only those plus BIRD's column notes, and Claude Opus 5.5 writes one query. No candidate voting and no agent loop. If the query errors, the model sees the error and tries again.

schemagate's main job is access control. It removes the tables the caller may not read before the model sees the schema. A benchmark doesn't test that part, but it shows the filtering doesn't cost accuracy.

What it isn't: the main BIRD board, which uses a hidden test set. Our first test result there was 72.11, and a rerun is pending.

來源:DEV Community · dev.to