How to use from the
Use from the
sentence-transformers library
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)

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.

Downloads last month
34
Safetensors
Model size
22.7M params
Tensor type
F32
·
Inference Providers NEW
This model isn't deployed by any Inference Provider. 🙋 Ask for provider support

Model tree for TommyPanLab/AAP-SQL-Candidate-Reranker