MaskSQL: Safeguarding Privacy for LLM-Based Text-to-SQL via Abstraction

Fuente: arXiv
Guardado en:
Detalles Bibliográficos
Autores principales: Abedini, Sepideh, Mohapatra, Shubhankar, Emerson, D. B., Shafieinejad, Masoumeh, Cresswell, Jesse C., He, Xi
Formato: Preprint
Publicado: 2025
Materias:
Acceso en línea:
Etiquetas: Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
_version_ 1866914066639880192
author Abedini, Sepideh
Mohapatra, Shubhankar
Emerson, D. B.
Shafieinejad, Masoumeh
Cresswell, Jesse C.
He, Xi
author_facet Abedini, Sepideh
Mohapatra, Shubhankar
Emerson, D. B.
Shafieinejad, Masoumeh
Cresswell, Jesse C.
He, Xi
contents Large language models (LLMs) have shown promising performance on tasks that require reasoning, such as text-to-SQL, code generation, and debugging. However, regulatory frameworks with strict privacy requirements constrain their integration into sensitive systems. State-of-the-art LLMs are also proprietary, costly, and resource-intensive, making local deployment impractical. Consequently, utilizing such LLMs often requires sharing data with third-party providers, raising privacy concerns and risking noncompliance with regulations. Although fine-tuned small language models (SLMs) can outperform LLMs on certain tasks and be deployed locally to mitigate privacy concerns, they underperform on more complex tasks such as text-to-SQL translation. In this work, we introduce MaskSQL, a text-to-SQL framework that utilizes abstraction as a privacy protection mechanism to mask sensitive information in LLM prompts. Unlike redaction, which removes content entirely, or generalization, which broadens tokens, abstraction retains essential information while discarding unnecessary details, striking an effective privacy-utility balance for the text-to-SQL task. Moreover, by providing mechanisms to control the privacy-utility tradeoff, MaskSQL facilitates adoption across a broader range of use cases. Our experimental results show that MaskSQL outperforms leading SLM-based text-to-SQL models and achieves performance approaching state-of-the-art LLM-based models, while preserving privacy.
format Preprint
id arxiv_https___arxiv_org_abs_2509_23459
institution arXiv
publishDate 2025
record_format arxiv
spellingShingle MaskSQL: Safeguarding Privacy for LLM-Based Text-to-SQL via Abstraction
Abedini, Sepideh
Mohapatra, Shubhankar
Emerson, D. B.
Shafieinejad, Masoumeh
Cresswell, Jesse C.
He, Xi
Cryptography and Security
Computation and Language
Large language models (LLMs) have shown promising performance on tasks that require reasoning, such as text-to-SQL, code generation, and debugging. However, regulatory frameworks with strict privacy requirements constrain their integration into sensitive systems. State-of-the-art LLMs are also proprietary, costly, and resource-intensive, making local deployment impractical. Consequently, utilizing such LLMs often requires sharing data with third-party providers, raising privacy concerns and risking noncompliance with regulations. Although fine-tuned small language models (SLMs) can outperform LLMs on certain tasks and be deployed locally to mitigate privacy concerns, they underperform on more complex tasks such as text-to-SQL translation. In this work, we introduce MaskSQL, a text-to-SQL framework that utilizes abstraction as a privacy protection mechanism to mask sensitive information in LLM prompts. Unlike redaction, which removes content entirely, or generalization, which broadens tokens, abstraction retains essential information while discarding unnecessary details, striking an effective privacy-utility balance for the text-to-SQL task. Moreover, by providing mechanisms to control the privacy-utility tradeoff, MaskSQL facilitates adoption across a broader range of use cases. Our experimental results show that MaskSQL outperforms leading SLM-based text-to-SQL models and achieves performance approaching state-of-the-art LLM-based models, while preserving privacy.
title MaskSQL: Safeguarding Privacy for LLM-Based Text-to-SQL via Abstraction
topic Cryptography and Security
Computation and Language
url https://arxiv.org/abs/2509.23459