Welcome to AI2sql Documentation

AI2sql is a powerful tool that helps you generate, optimize, and manage SQL queries using natural language processing. This documentation will guide you through all the features and capabilities of the platform.

Key Features

  • Natural language to SQL conversion
  • Multiple database support (MySQL, PostgreSQL, SQL Server, Oracle, etc.)
  • Query optimization and explanation
  • Manual schema builder
  • Database connection management

Getting Started

To get started with AI2sql, you'll need to:

  1. Set up your database connections or create a manual schema
  2. Navigate to the Query Builder
  3. Start generating SQL queries using natural language

Pro Tip

Check out our Quick Start Guide for a step-by-step walkthrough of the basic features.

How to Use the Save and Load Feature

The Save and Load feature allows you to store your generated SQL queries along with the prompt you used to generate them. You can later load these saved queries to review, re-run, or delete them as needed.

Saving a Query

  • Generate a SQL query using the Query Builder.
  • Enter your prompt (a natural language description of what you want to achieve) in the input field.
  • Click the Save button to store the generated SQL along with your prompt.
  • The query is now saved to your account for future use.

Loading a Saved Query

  • Click the Load Saved Query button on this page.
  • A modal window will appear, showing a list of all your saved queries.
  • Click the Select button next to the desired query.
  • The saved prompt and generated SQL will then load into the display area below.
  • You can review the loaded content and re-run the query if needed.

Deleting a Saved Query

  • Within the modal, click the Delete button next to the query you wish to remove.
  • Confirm the deletion when prompted; the query will then be removed from your saved list.