background

How does AskYourDatabase protect your data?

How does AskYourDatabase protect your data?
Sheldon Niu
Sheldon Niu

In this article, we'll explore the workings of the AskYourDatabase plugin and desktop application, focusing on how we safeguard your data.

How Plugin works

Here's a simplified diagram illustrating the process:

A diagram showing the process flow of the AskYourDatabase plugin. It starts with the user providing database credentials to ChatGPT, followed by the transmission of these credentials to the server. The server then attempts to establish a connection with the user's database, highlighting the steps involved in this plugin's operation.
Flowchart Illustrating the AskYourDatabase Plugin Process

To use the plugin, you need to provide ChatGPT with your database credentials. These credentials are then transmitted to our server, which attempts to establish a connection with your database.

However, this approach raises several security concerns:

  1. While we don't store your credentials, they are still disclosed in the ChatGPT chat history, potentially being used in training the OpenAI model.
  2. We don't interact with your database beyond establishing a connection. However, the ability to connect to your database from our server means that, in the event of a cyber attack on our server, there's a risk that hackers could access your database through our server.

Measures to Protect Your Data:

  1. We ensure that your credentials are never stored.
  2. All network communications are secured using HTTPS protocol.

Despite these precautions, we recommend the following steps to further secure your data:

  1. Create a read-only user account if your intention is solely to query data.
  2. Whitelist our static IP to allow database connections.
  3. Change your password after completing your tasks.

How Desktop works

The following image illustrates the desktop application's process:

AskYourDatabase Desktop connects your db locally and securely
How AskYourDatabase Desktop works

The desktop application establishes a connection to your database directly from your local computer (future updates will include SSH tunnel support).

Your credentials are securely stored in your local vault and are not transmitted elsewhere. Only your queries and the database schema information are sent to our server.

Our server acts merely as a conduit to OpenAI, and we do not store your conversations.

Thus, the desktop version maintains a high level of security for most use cases.

If privacy is a paramount concern (for instance, if you wish to prevent OpenAI from using your conversation history in model training), we recommend considering ChatGPT Enterprise.

We offer integration with ChatGPT Enterprise and are available for demos upon request.

Summary


Both the AskYourDatabase plugin and desktop application are designed with your data security in mind.

While the plugin requires careful handling of database credentials and adherence to recommended security practices, the desktop application offers enhanced privacy by handling connections locally and storing credentials securely on your device.

We continuously strive to balance functionality with security, ensuring that your data remains protected. For those with heightened privacy needs, our integration with ChatGPT Enterprise provides an additional layer of security, aligning with the most stringent data protection standards.


More Blogs

Cover Image for Streamlining ERP Integration and Data Management with AskYourDatabase

Streamlining ERP Integration and Data Management with AskYourDatabase

Learn how Tobias, a PMO leader at the German subsidiary of a major U.S.-based food corporation, successfully integrated multiple ERP systems using AskYourDatabase to streamline data management, reduce errors, and foster collaboration between business and IT teams.

Sheldon Niu
Sheldon Niu
Cover Image for How to Query Database Using AI: A Comprehensive Guide

How to Query Database Using AI: A Comprehensive Guide

Learn how to effectively query databases using AI tools, with best practices for crafting queries, building reference guides, and leveraging schema information. Discover why AskYourDatabase is the ideal solution for AI-powered database querying.

Sheldon Niu
Sheldon Niu
Cover Image for Developing AI-powered Chatbot for Snowflake Data Warehouses: Unique Ideas & Workarounds

Developing AI-powered Chatbot for Snowflake Data Warehouses: Unique Ideas & Workarounds

Explore innovative approaches and tools for creating an AI chatbot that seamlessly interacts with Snowflake data warehouses. Discover various methods, including a rapid, no-code solution using AskYourDatabase, to enhance data accessibility and analysis within your organization.

Sheldon Niu
Sheldon Niu
Cover Image for Building an AI Chatbot for Google BigQuery: Enhancing Data Accessibility

Building an AI Chatbot for Google BigQuery: Enhancing Data Accessibility

Explore innovative approaches to create an AI chatbot for Google BigQuery, including a rapid, no-code solution with AskYourDatabase. Learn how to improve data analysis and accessibility in your organization with these cutting-edge strategies.

Sheldon Niu
Sheldon Niu
Cover Image for Creating an AI Chatbot for Microsoft SQL Server Databases

Creating an AI Chatbot for Microsoft SQL Server Databases

Discover effective strategies and tools for developing an AI chatbot that interacts with Microsoft SQL Server databases. Learn about various approaches, including a quick, code-free implementation using AskYourDatabase, to improve data accessibility and analysis in your organization.

Sheldon Niu
Sheldon Niu
Cover Image for Building an AI Chatbot that queries MySQL Databases

Building an AI Chatbot that queries MySQL Databases

Explore the best practices and solutions for building an AI chatbot for MySQL databases. Learn about different approaches, including using AskYourDatabase for a quick and code-free implementation, to enhance data accessibility and analysis for your organization.

Sheldon Niu
Sheldon Niu
Cover Image for Developing an AI Chatbot that queries PostgreSQL Database

Developing an AI Chatbot that queries PostgreSQL Database

Discover effective strategies and solutions for creating an AI chatbot that interacts with PostgreSQL databases. Learn about various approaches, including the use of AskYourDatabase for rapid, code-free implementation, to improve data accessibility and analysis within your organization.

Sheldon Niu
Sheldon Niu
Query SQL database in natural language

Query SQL database in natural language

The best approach depends on your team and whether you can invest time in building a SQL AI Agent. For technical teams who want more customized solutions, tools like Langchain may be the best choice. For non-tech teams, choosing tools like AskYourDatabase will likely be the lowest-cost option.

Sheldon Niu
Sheldon Niu
How AskYourDatabase has saved 40 hours per week for SmartLead.ai

How AskYourDatabase has saved 40 hours per week for SmartLead.ai

AskYourDatabase has helped the famous cold email SaaS company SmartLead.ai save 40 hours each week between the CS team and the engineering team. More importantly, the tool has taught the CS team the skills crucial for their growth and success.

Sheldon Niu
Sheldon Niu
;