An interactive web interface for extracting SQL dependencies using Large Language Models.

This web application is a Streamlit-based showcase for SQLDeps, allowing users to interactively explore how large language models can analyze SQL queries and extract their underlying table and column dependencies.

• 🔍 Instantly visualize SQL query dependencies
• 🤖 Powered by advanced language models
• 📊 Interactive, real-time dependency extraction
• 💾 Optional database schema validation

Consider this SQL query:

WITH user_orders AS (
    SELECT o.user_id, COUNT(*) AS order_count 
    FROM orders o 
    JOIN users u ON o.user_id = u.id 
    WHERE u.status = 'active' 
    GROUP BY o.user_id
)
CREATE TABLE transactions.user_order_summary AS 
SELECT * FROM user_orders;

When processed, the application shall return:

• Dependencies: orders and users tables
• Used columns: user_id, status
• Output: transactions.user_order_summary table

Try SQLDeps Web Application

This web application provides complimentary API access to:

• OpenAI
• Groq
• DeepSeek

Due to the showcase nature of this service, we offer a limited number of free requests. If the service becomes temporarily unavailable or unresponsive, this may be due to exhausted API credits.

For unlimited or production use, we recommend:

• Setting up your own API keys
• Exploring the SQLDeps library

Part of the SQLDeps project, demonstrating the power of AI in understanding SQL dependencies.

MIT License