AskDB: Natural Language to SQL for Developers

AskDB is a desktop application designed to convert natural language queries into SQL for PostgreSQL, MySQL, and SQLite databases. Built with PySide6, SQLAlchemy, LangChain, and OpenAI, it enables users to interact with databases using plain English, making data analysis faster and more accessible. Ideal for developers and data professionals, AskDB provides a clean desktop interface with features like streaming responses, a SQL editor, results table, and connection management. Queries run locally, with only prompt text sent to the configured LLM provider (OpenAI), ensuring privacy and efficiency.

Key Features:

• Natural Language to SQL Conversion: Uses OpenAI via LangChain to translate natural language into SQL queries.
• Desktop Application: Built with PySide6 for a clean, intuitive UI.
• Local Execution: Queries run locally; only prompt text is sent to the LLM provider.
• SQL Editor: Supports manual SQL execution via a custom query editor.
• Streaming Responses: Real-time results delivery.
• Connection Management: Easily manage database connections.
• Results Table: View query results in a structured table format.
• Cross-Platform Support: Available for macOS via PyInstaller (.app and .dmg).
• Customizable Settings: Configure OpenAI API key, model selection (default: gpt-4o-mini), and optional LangSmith tracing.

Pricing: AskDB is available for free with no subscription required.

Conclusion: AskDB is a powerful, privacy-conscious tool that empowers developers and data analysts to interact with databases using natural language, combining the ease of AI with the reliability of local execution.