SQL Database Query

How to Complete the SQL Database Query Form?

Looking at this SQL Database Query loader form, here's what you need to do to complete it:

Step-by-Step Instructions:

1. Name (Required)

  • Enter a name for your data source in the text box

  • This helps you identify your database query results later

  • Example: "Customer Database," "Sales Report," or "Product Inventory"

  • The placeholder shows "My SQL Database" as an example

  • ⚠️ This field is required (red warning shown)

2. URI (Required)

  • Enter your database connection URI (connection string)

  • Format examples:

    • MySQL: mysql://user:password@localhost:3306/mydb

    • PostgreSQL: postgres://user:password@localhost:5432/mydb

    • SQLite: sqlite:///path/to/database.db

  • Replace user, password, localhost, port, and database name with your actual values

  • ⚠️ This field is required (red warning shown)

3. SQL Query (Required)

  • Write your SQL SELECT query in the text area

  • Important: Only SELECT queries are supported (no INSERT, UPDATE, DELETE)

  • Example queries:

    • SELECT * FROM customers

    • SELECT name, email FROM users WHERE active = 1

    • SELECT product_name, price FROM products ORDER BY price DESC

  • The placeholder shows SELECT * FROM my_table as an example

  • ⚠️ This field is required (red warning shown)

4. Chunk Size

  • Set how many tokens or characters should be in each chunk

  • Default value is 1024 (recommended for most cases)

  • You can change this number if needed

  • This controls how your query results are divided for processing

5. Select Embedding Model

  • Default "OpenAI - Text Embedding 3 Small" is already selected

  • You can change this by clicking the dropdown if needed

  • This model processes and understands your database query results

6. Review Cost Warning

  • ⚠️ Important: Check the yellow warning box

  • Data import costs 0.035 tokens per word

  • Consider the size of your query results

7. Final Step

  • Click the "Save" button at the bottom

  • The system will connect to your database, execute the query, and process the results

  • The data will be converted into text that AI can work with

Key Features:

  • Live Database Connection: Connects directly to your database

  • Query Results Processing: Converts query results into searchable text

  • Multiple Database Support: Works with MySQL, PostgreSQL, SQLite, and more

Database Connection Examples:

MySQL:

textmysql://username:[email protected]:3306/database_name

PostgreSQL:

textpostgresql://username:[email protected]:5432/database_name

SQL Server:

textmssql://username:[email protected]:1433/database_name

Security Notes:

  • Make sure your database allows external connections

  • Use secure credentials

  • Consider creating a read-only database user for this purpose

  • Ensure your database server is accessible from the internet (if cloud-hosted)

Perfect For:

  • Customer data analysis

  • Sales reporting

  • Inventory management

  • User analytics

  • Financial data processing

  • Any structured data in databases

Simple Summary:

  1. Give your database query a name

  2. Enter your database connection URI

  3. Write your SELECT query

  4. Adjust settings if needed (or keep defaults)

  5. Click Save

  6. Done!

Your database query results will be processed and converted into text that AI can understand, search through, and analyze for insights, patterns, and answers to your questions!

Important: Make sure your database is accessible and your credentials are correct before saving.

PreviousCSV FileNextWebsite

Last updated