Skip to content

SQLDeps: SQL Dependency Extractor

SQLDeps Logo

A powerful tool that automatically extracts and maps SQL dependencies and outputs using Large Language Models (LLMs).

Overview

SQLDeps analyzes SQL scripts to identify:

  1. Dependencies: Tables and columns that must exist BEFORE query execution
  2. Outputs: Tables and columns permanently CREATED or MODIFIED by the query

It intelligently filters out temporary constructs like CTEs and derived tables, focusing only on the real database objects that matter.

Key Benefits

  • 🛠️ Change Management: Safely modify schemas by identifying true dependencies
  • 💾 Storage Optimization: Focus resources on essential tables and columns
  • 🚢 Migration Planning: Precisely determine what needs to be migrated
  • 📝 Project Documentation: Create comprehensive maps of database dependencies

Why SQLDeps?

Traditional approaches to SQL dependency tracking:

  • Manual Inspection: Time-consuming and error-prone
  • Traditional Parsers: Lacks context and intelligence for complex SQL

SQLDeps leverages the power of Large Language Models to provide intelligent, accurate dependency extraction that works across SQL dialects and complexity levels.

Supported LLM Providers

All models availables on Groq, OpenAI, and DeepSeek.

Getting Started

# Install the package
pip install sqldeps

# Basic usage
sqldeps extract path/to/query.sql

Check out the Quick Start guide for more details.