> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flowx.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Testing data sources from Runtime

> Run database operations and SQL queries against a deployed build to validate data sources without triggering a workflow.

export const release_0 = "5.10"

<Info>
  Data sources on a deployed build can be tested directly from **Runtime**: run a database operation or an SQL query and inspect the response, without wiring it into a workflow first. Use this to validate a data source after deploy or to investigate why an operation misbehaves in an environment.
</Info>

## Where to find it

<Steps>
  <Step title="Open the Builds list">
    In your project, go to **Runtime** and open the **Builds** list.
  </Step>

  <Step title="Open the build's test menu">
    On the build you want to test against, open the test actions menu.
  </Step>

  <Step title="Pick the test action for your data source">
    The available entry depends on the data source type configured in the build.
  </Step>
</Steps>

| Data source                       | Test action                                                                                                   |
| --------------------------------- | ------------------------------------------------------------------------------------------------------------- |
| FlowX Database, unmanaged MongoDB | **Test operation** (this page)                                                                                |
| Oracle, PostgreSQL                | **Test query** (this page)                                                                                    |
| RESTful system                    | **Test endpoint**                                                                                             |
| SOAP system                       | **Test SOAP operation** — see [SOAP system](./soap-system#testing-an-operation)                               |
| Knowledge Base                    | **Test knowledge base** — see [Testing a knowledge base](./knowledge-base-integration/testing-knowledge-base) |

The same menu also offers **Test build** (run a process from the build) and **Test workflow** (run an integration workflow) — see the [Builds](/5.9/docs/projects/runtime/builds) documentation for the full list.

<Frame>
  ![Build test actions menu in Runtime, with Test operation and Test query entries](https://s3.eu-west-1.amazonaws.com/docx.flowx.ai/5.9/test_build_options.png)
</Frame>

Testing data sources requires the **data\_source\_read** permission. Test runs are recorded in the audit log.

***

## Testing SQL queries (Oracle and PostgreSQL)

<Info>
  **Available starting with FlowX.AI 5.9.2**
</Info>

**Test query** opens a full-screen testing modal for the SQL data sources in the build:

1. Pick a query from the selector in the modal header — queries are grouped by data source, and you can filter with **Search query**. Data sources without queries show **No queries available**.
2. Review or edit the query in the **Query Arguments** editor (SQL, with autocomplete and a schema preview of the data source's entities), and fill in any **Input Parameters** the query uses.
3. Click **Test**. The **Response** pane shows the result as JSON, along with status, execution time, and size. Failures are shown with the database error message.

When opened from Runtime, the modal is read-only for the query definition — edits you make in the editor are for the test run only and cannot be saved to the build.

<Warning>
  **Queries run against the live database of that environment, and they are not restricted to read-only statements.** An `UPDATE`, `INSERT`, or `DELETE` executes for real and may modify data — the modal shows the same warning. Test destructive queries only against non-production environments.
</Warning>

***

## Testing database operations (FlowX Database and unmanaged MongoDB)

**Test operation** opens the equivalent modal for NoSQL data sources: pick an operation from the selector in the modal header (filter with **Search operation**), provide any input parameters, and click **Test** to see the operation's response. The data source's schema is available for reference from the modal.

### Browsing documents

<Badge color="blue" icon="cloud">SaaS · {release_0}</Badge>

<Info>
  **Available on SaaS with FlowX.AI {release_0}.** This feature is live on managed (SaaS) deployments now. Self-hosted deployments receive it with the next LTS release.
</Info>

For FlowX Database and unmanaged MongoDB data sources, the test modal gains a **Documents** tab alongside **Test**: browse the collection's documents directly, filtering either visually with the **Query Builder** or by writing **JSON** filter and sort expressions, then click **Run**. Use it to check what an operation actually changed without writing a query for it.

***

## Related resources

<CardGroup cols={2}>
  <Card title="FlowX Database" icon="database" href="./flowx-database">
    Collections, operations, and usage in workflows
  </Card>

  <Card title="Oracle database" icon="database" href="./oracle-database">
    Add an Oracle data source and define queries
  </Card>

  <Card title="PostgreSQL database" icon="database" href="./postgresql-database">
    Add a PostgreSQL data source and define queries
  </Card>

  <Card title="Testing a knowledge base" icon="flask" href="./knowledge-base-integration/testing-knowledge-base">
    The equivalent testing surface for knowledge bases
  </Card>
</CardGroup>


## Related topics

- [Builds](/5.9/docs/projects/runtime/builds.md)
- [MCP Data Sources](/5.9/docs/platform-deep-dive/integrations/mcp-integration/adding-mcp-data-source.md)
- [SOAP System](/5.9/docs/platform-deep-dive/integrations/soap-system.md)
- [Data mappers](/5.9/docs/building-blocks/process/data-mappers.md)
- [Testing a knowledge base](/5.9/docs/platform-deep-dive/integrations/knowledge-base-integration/testing-knowledge-base.md)