AskDB

AskDB

Revolutionize the way we interact with SQL databases using Generative AI

Stars: 72

Visit
 screenshot

AskDB is a revolutionary application that simplifies the way users interact with SQL databases. It allows users to query databases in plain English, provides instant answers, and offers AI-assisted query writing and database exploration. AskDB benefits business analysts, data scientists, managers, developers, and database administrators by making querying databases intuitive, effortless, and safe. It offers features like natural language querying, instant insight from data, multi-database connectivity, intelligent query suggestions, data privacy, and easy data export.

README:

ยฉ 2024 Phan Xuan Quang / AskDB

  • What if you're a person who need to do ad-hoc data queries but are not technical enough to write SQL queries?
  • What if you could simply ask your database questions in plain English and get instant answers?
  • What if you even don't know what to do with your raw data?

SplashScreen scale-200

Introducing AskDB, the revolutionary application that simplifies the way you interact with your SQL databases, designed for both SQL database administrator, those who are new to SQL, and those who want to do data analysis, AskDB makes querying databases intuitive, effortless, and safe.

๐Ÿ’ผ Who Benefits from AskDB

  • Business Analysts: Get the data you need without waiting for the IT department.
  • Data Scientists: Quickly explore and understand new databases without mastering each one's SQL flavor.
  • Managers: Make data-driven decisions by easily querying your company's databases.
  • Developers: Boost your productivity with AI-assisted query writing and database exploration.
  • Database Administrators: Empower your team while maintaining control and safety.

๐Ÿ“˜ Usage Guidance

Guidance Video

  • Step 1: Download and extract the AskDB.zip from THIS release.
  • Step 2: Run the AskDB.exe file (skip the Unknown Published warning from Windows if any).
  • Step 3: Follow the instruction to get started.
  • Step 4: Ask AskDB everything about your SQL database.

๐ŸŒŸ How AskDB Helps You

Natural Language Querying

image

AskDB analyzes your database structure and provides suggestions for both natural language queries and SQL commands.

  • No more struggling with complex SQL syntax
  • Simply describe what you want to know, and AskDB will help to get the results.
  • Perfect for the ones who don't know what to query

Instant Insight From Your Data

image

AskDB can analyze your output data and give some quick insight to help you with the decision making.

  • Get the instant insight from your data with only one click
  • Perfect for managers, analysts, and anyone who needs quick data insights

Seamless Multi-Database Connectivity

image

Whether you're working with SQL Server, MySQL, PostgreSQL, or SQLite, AskDB has got you covered. Switch between databases seamlessly, all within the same intuitive interface.

  • Seamlessly connects with SQL Server, MySQL, PostgreSQL, and SQLite
  • Be able to analyze up to 500 tables

Intelligent Query Suggestions

image image

  • Get intelligent query suggestions based on the structure of your selected tables
  • Get query suggestions in both SQL and natural language, customized to your computer's language settings!
  • Remember what you inputed for faster typing and effectively querying

Safety First

image

Accidentally trying to drop a table? AskDB has your back. Our intelligent system detects potentially dangerous queries and stops them in their tracks, protecting your valuable data.

  • The credentials such as API keys, connection strings, your querying history are stored on your local machine in an encrypted format.
  • For the queries which may make changes to the database, AskDB will ask for your confirmation for the execution.
  • Automatic detection and cancellation of potentially harmful queries

Export with Ease

image

  • Transform query results into ready-to-use CSV files with a single click
  • Get the SQL query translated from your natural language query

๐Ÿ”’ Data Privacy

Your data, including your Gemini API Keys, connection strings, and the results queried from your databases, are securely stored on your local device only. This data will be automatically deleted permanently when you clean the Temp folder of your Windows. We do not store or retain your data on our servers, ensuring that your information remains private and secure at all times.

If you have any concerns or questions about our data privacy practices, please feel free to open a new issue.

๐Ÿ‘ Contribution

We welcome contributions and encourage you to help this project better and better. If you encounter any issues or have suggestions for improvements, please open an issue in the Issues section of the repository. Before submitting a pull request, please ensure that your changes are well-documented in the Pull Request description.

Thank you for your contribution and for helping to make this project better! ๐ŸŽ‰

For Tasks:

Click tags to check more tools for each tasks

For Jobs:

Alternative AI tools for AskDB

Similar Open Source Tools

For similar tasks

For similar jobs