🚀 How To: Setup a Database

Having a database is key to how AI Query functions and is a cornerstone of the platform. Let's take a look at how to setup a database.

Supported Databases

AI Query supports:

• PostgreSQL
• MySQL
• MariaDB
• SQL Server

We continue to add new databases based on our User Community (opens in a new tab) feedback.

Steps

On the AI Query Dashboard, navigate to Databases.

To setup a new database, navigate to Add New Database:

• Enter a Name for your database
• Select the Type of the database

At this point, you have two options that allow you to define your database:

If you decide to go with the fastest and recommended approach:

• Click Import From Script
• Copy/paste your exported database schema from your database server
• Click Import

If you decide to go with the manual approach:

• Click Create First Table
• Enter the Name for your table
• Click + Add Column and enter the Name and Type for each field in the table (repeat for each field in the table)
• Click ✔ to save
• Click + Add Table to repeat the steps above for each table

You'll see that you now have a Database setup and ready for use! 😀