AI2sql Docs
Go to AppContact
  • 1. Introduction
    • 1.1. What is AI2SQL?
    • 1.2. Key features of AI2SQL
    • 1.3. How to get started with AI2SQL
    • 1.4. What Users Can Ask AI2SQL
  • 2. AI2SQL Dashboard
    • 2.1. Accessing the dashboard
    • 2.2. Generating SQL based on predefined datasets
    • 2.3. Exploring sample queries and use cases
  • 3. Managing Tables
    • 3.1. Importing tables using DDL
    • 3.2. Manually adding tables
    • 3.3. Editing, Updating, and Deleting Table Information
    • 3.4. Importing Database Schema via CSV
  • 4. AI2SQL Workspace
    • 4.1. Navigating the workspace
    • 4.2. Generating SQL for specific database engines
    • 4.3. Selecting tables for SQL generation
    • 4.4. Saving and organizing queries in the workspace
  • 5. Formatting SQL
    • 5.1. Accessing the SQL formatter
    • 5.2. Customizing formatting options
    • 5.3. Applying formatting to your SQL queries
  • 6. SQL Fixer
    • 6.1. Identifying SQL errors with SQL Fixer
    • 6.2. Understanding common SQL error messages
    • 6.3. Resolving SQL errors using AI2SQL's suggestions
    • 6.4. Handling Long SQL Queries
  • 7. Formula Generator
    • 7.1. Overview of Formula Generator
    • 7.2. Excel, Google Sheets, and regex formula translation
    • 7.3. Power BI DAX formula translation
    • 7.4. Airtable formula translation
    • 7.5. Using Formula Generator to enhance SQL queries
  • 8. CSV Analyzer
  • 9. Database Connectors
    • 9.1. Supported database connectors
    • 9.2. Setting up database connections (MySQL, SQL Server, or PostgreSQL)
    • 9.2.1. AI2sql Oracle Cloud Connector
    • 9.3. Setting up MongoDB Connectors
    • 9.4. Google BigQuery Setup and Service Account Key Creation
    • 9.5. Generating SQL queries for connected databases
    • 9.6. Setting up Snowflake Connectors
    • 9.7. Troubleshooting AI2sql Connector Issues: A Comprehensive Checklist
    • 9.8. Requesting new database connectors
    • 9.9. System Security Overview
  • 10. Dataset Questions Generation
  • 11. AI2SQL ChatGPT Plugin User Guide
    • 11.1. Introduction
    • 11.2. Getting Started
    • 11.3. Obtaining Your Token
    • 11.4. Using Your Token
    • 11.5. Connecting Your MSSQL (SQL Server) Database
    • 11.6. Connecting Your MySQL Database
    • 11.7. Connecting Your PostgreSQL Database
    • 11.8. Generating SQL Queries
    • 11.9. Troubleshooting
  • 12. Troubleshooting and Support
    • 9.1. Common issues and solutions
    • 12.2. Chat Support
    • 12.3. Contacting AI2SQL support
    • 12.4. Community resources and forums
  • 13. Templates
    • 13.1. Custom Template Creation
    • 13.2. Save the Template
    • 13.3. Generate SQL Using Template
  • 14. AI2sql: SQL Generation from Database ER Diagrams
    • 14.1. Introduction
    • 14.2. SQL Generation Process
    • 14.3. Troubleshooting & FAQs
  • 15. AI2sql API Integration
  • 16. AI2SQL Dictionary Template
  • 17. AI2sql GPTs
    • 17.1. Getting Started
    • 17.2. Obtaining Your Token
    • 17.3. Connecting Your MySQL Database
  • 18. Connecting Your Local Database
  • 19. SQL File Uploader
    • 19.1 Generating SQL queries
Powered by GitBook
On this page
  • Uploading SQL Schema CSV File
  • How to Upload a SQL Schema CSV File
  • Generating the CSV File
  • CSV File Format
  • Important Notes
  1. 3. Managing Tables

3.4. Importing Database Schema via CSV

Previous3.3. Editing, Updating, and Deleting Table InformationNext4. AI2SQL Workspace

Last updated 9 months ago

Uploading SQL Schema CSV File

Our SQL generator tool allows you to import your database schema information using a CSV file. This feature is particularly useful when you want to quickly transfer your database structure without writing DDL statements manually.

How to Upload a SQL Schema CSV File

  1. Navigate to the "Upload SQL Schema CSV File" screen in the tool.

  2. You'll see a form with the following elements:

    • A text input field labeled "File Name*"

    • An upload area with the message "Click to upload a CSV file."

    • A "Finish" button at the bottom

  3. Enter a name for your file in the "File Name" field. This doesn't have to match the actual filename, but should be descriptive. For example, you might enter "customers" for a schema related to customer data.

  4. Click on the upload area. This will open a file browser on your computer.

  5. Select the CSV file containing your schema information.

  6. Once your file is selected, it will appear in the upload area.

  7. Click the "Finish" button to complete the upload process.

Generating the CSV File

To create the CSV file for upload, you'll need to run a query on your database to extract the schema information. Here are queries for common database systems:

For SQL Server

SELECT
  TABLE_SCHEMA AS [Schema],
  TABLE_NAME AS [Table],
  COLUMN_NAME AS [Column],
  DATA_TYPE AS [Type]
FROM
  INFORMATION_SCHEMA.COLUMNS
WHERE
  TABLE_SCHEMA = 'dbo'

For MySQL

sqlCopySELECT
  TABLE_SCHEMA AS 'Schema',
  TABLE_NAME AS 'Table',
  COLUMN_NAME AS 'Column',
  DATA_TYPE AS 'Type'
FROM
  INFORMATION_SCHEMA.COLUMNS
WHERE
  TABLE_SCHEMA = "YOUR_DATABASE_NAME"

Replace "YOUR_DATABASE_NAME" with the name of your database.

Steps to Generate and Prepare the CSV:

  1. Run the appropriate query for your database system.

  2. Export the results to a CSV file.

  3. Ensure the CSV file has the following headers: Schema,Table,Column,Type

  4. Save the file with a .csv extension.

CSV File Format

Your CSV file should look like this:

CopySchema,Table,Column,Type
dbo,Customers,CustomerID,int
dbo,Customers,FirstName,varchar
dbo,Customers,LastName,varchar
dbo,Orders,OrderID,int
dbo,Orders,CustomerID,int
dbo,Orders,OrderDate,datetime

Important Notes

  • Ensure your CSV file contains only schema information, not actual data.

  • The tool expects the CSV to have the exact column headers as shown above.

  • If your database doesn't use schemas, you can leave the Schema column blank or use a placeholder value.

  • Large databases may result in large CSV files. If you encounter issues, consider splitting your schema into multiple CSV files.

After uploading, you can use our tool to visualize, modify, or generate SQL from your schema. If you encounter any issues during the upload process, please check our troubleshooting guide or contact our support team.

This document provides clear instructions on how to use the CSV upload feature, including how to generate the necessary CSV file from different database systems. It also includes important notes and formatting requirements to ensure a smooth upload process.