Instructions to use TommyPanLab/AAP-SQL-Candidate-Reranker with libraries, inference providers, notebooks, and local apps. Follow these links to get started.
- Libraries
- sentence-transformers
How to use TommyPanLab/AAP-SQL-Candidate-Reranker with sentence-transformers:
from sentence_transformers import CrossEncoder model = CrossEncoder("TommyPanLab/AAP-SQL-Candidate-Reranker") query = "Which planet is known as the Red Planet?" passages = [ "Venus is often called Earth's twin because of its similar size and proximity.", "Mars, known for its reddish appearance, is often referred to as the Red Planet.", "Jupiter, the largest planet in our solar system, has a prominent red spot.", "Saturn, famous for its rings, is sometimes mistaken for the Red Planet." ] scores = model.predict([(query, passage) for passage in passages]) print(scores) - Notebooks
- Google Colab
- Kaggle
language:
- en
library_name: sentence-transformers
pipeline_tag: text-ranking
base_model: cross-encoder/ms-marco-MiniLM-L6-v2
tags:
- sentence-transformers
- text-ranking
- text2sql
- schema-linking
- aap-sql
AAP-SQL candidate reranker
AAP-SQL 候選重排序器是完整 AAP-SQL 設定中的 cross-encoder。它對欄位檢索器召回的候選欄位重新評分,保留前 10 個核心欄位供後續提示增強使用。
AAP-SQL candidate reranker is the cross-encoder used after the first stage of schema retrieval. It scores the retrieved candidate columns and retains the top 10 core columns for prompt augmentation.
Model details
- Base model: cross-encoder/ms-marco-MiniLM-L6-v2
- Training objective: BinaryCrossEntropyLoss
- Training seed: 42
- Training data: schema-ranking examples derived from the BIRD training split and schema descriptions
- Expected library: sentence-transformers>=5.1.2
AAP-SQL publication branch
The complete AAP-SQL workflow, research method terminology, BIRD directory layout, and reproduction instructions are maintained in the GitHub publication branch.
Use with AAP-SQL
Download this repository into the path expected by the final runner:
hf download TommyPanLab/AAP-SQL-Candidate-Reranker --local-dir models/cross_encoder_schema_paper_repro
Direct loading:
from sentence_transformers import CrossEncoder
model = CrossEncoder("TommyPanLab/AAP-SQL-Candidate-Reranker")
scores = model.predict([ ("user question", "table.column: column description") ])
Data and license notice
The training examples were derived from the BIRD benchmark. Review the BIRD project terms before using the model. No additional license has been declared for these fine-tuned weights; the upstream model and dataset terms still apply.