PulseAugur
EN
LIVE 03:30:58

Schemagate text-to-SQL system achieves 63.7% success on Oracle databases

The Schemagate text-to-SQL system has achieved a 63.7% first-try success rate on Oracle databases, significantly outperforming previous benchmarks. This improvement is attributed to specific prompt engineering techniques, including handling Oracle's alias and reserved word conventions, and correctly formatting table names. The system's performance was evaluated on the UniQL dataset, with results showing a notable advantage over models like Claude-4.5-Sonnet, which previously held the best published Oracle score at 49.61%. AI

IMPACT Improves text-to-SQL accuracy on challenging database systems like Oracle, potentially enhancing data analysis capabilities.

RANK_REASON New benchmark results for a text-to-SQL system on a specific database dialect. [lever_c_demoted from research: ic=1 ai=1.0]

Read on dev.to — LLM tag →

AI-generated summary · Google Gemini · from 1 sources. How we write summaries →

Schemagate text-to-SQL system achieves 63.7% success on Oracle databases

How we ranked this

Signal score
52 / 100
Composite score across the factors below. Higher = stronger signal that this story matters right now.
Newsworthiness bucket
Tool
New benchmark results for a text-to-SQL system on a specific database dialect. [lever_c_demoted from research: ic=1 ai=1.0]
Source corroboration
Single-source cluster
Only one publisher covered this so far. Single-source stories can still rank when the publisher is high-authority, but they lack cross-source corroboration.
Topics
product, model release
Editorial topic classification. Feeds into how the story surfaces on /topic/<slug> hub pages and into the per-entity coverage mix.
AI-industry relevance
High
Clearly on-topic for AI-industry coverage.
Story freshness
Breaking (< 6h)
Fresh story with cross-source coverage still developing. Ranking may shift as more sources report.

Full methodology in our editorial standards.

COVERAGE [1]

  1. dev.to — LLM tag TIER_1 English(EN) · Ashish sinha ·

    Text-to-SQL on Oracle: 63.7% first try, on a benchmark my bug reports helped fix

    <p>Most text-to-SQL prompts carry the whole schema. schemagate sends only the tables the question needs: <strong>91% fewer schema tokens</strong> on 50+ table databases. It is <strong>#1 on BIRD's Mini-Dev leaderboard</strong> in SQLite, PostgreSQL and MySQL (81.0 / 72.6 / 72.4),…