Skip to content

Revolutionize the way we interact with SQL databases using Generative AI

Notifications You must be signed in to change notification settings

phanxuanquang/AskDB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

92 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

© 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

Quick Insights

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 up to 100 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! 🎉