Skip to main content

How-to: Generate Test Data

Learn how SQAI generates realistic SQL and API test data based on your schemas and models. This guide explains how to use SQAI to create lightweight injection queries that you can copy and execute directly in your own database management tools.

Updated today

SQAI Suite aids in test data creation by intelligently generating realistic, contextually correct data tailored to your specific needs. It is important to note that SQAI is not a fully fledged data virtualization or masking platform like Delphix or Tonic; rather, it serves as a powerful assistant for generating lightweight injection scripts based on your existing structures.

How it Works

  1. Contextual Awareness: If you are working with open-source technologies or publicly defined schemas, you can provide SQAI Suite with a link to that public data model. For private systems, simply provide SQAI with your schema, data model, and a small data blob as an example.

    A screenshot of a chat

AI-generated content may be incorrect.
  2. Model Analysis: Our Virtual Test Engineers crawl and analyze the model to extract all necessary structural and relational information. From this deep understanding, SQAI generates highly realistic test data—from unique user profiles to complex transactional data—that aligns perfectly with your application's context.

    A screenshot of a computer

AI-generated content may be incorrect.


  3. Actionable Output: This data is delivered as ready-to-use SQL queries or API payloads within easy-to-copy code blocks.

    A screenshot of a computer

AI-generated content may be incorrect.

Key Usage Note

Because SQAI focuses on agility and lightweight data generation, it does not connect directly to your production or test databases to execute changes. You must copy the generated query from the SQAI code block and manually execute it within your chosen Database Management Platform to inject the data.

This process eliminates the manual effort of writing complex inserts from scratch while ensuring your testing remains accurate, diverse, and relevant.

Did this answer your question?