> ## 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.

> [!NOTE]
>
> 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.

## Where to find it

**1. Open the Builds list**

In your project, go to **Runtime** and open the **Builds** list.

**2. Open the build's test menu**

On the build you want to test against, open the test actions menu.

**3. Pick the test action for your data source**

The available entry depends on the data source type configured in the build.

| 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](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/soap-system.md#testing-an-operation) |
| Knowledge Base | **Test knowledge base** — see [Testing a knowledge base](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/knowledge-base-integration/testing-knowledge-base.md) |

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

![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)

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

***

## Testing SQL queries (Oracle and PostgreSQL)

> [!NOTE]
>
> **Available starting with FlowX.AI 5.9.2**

**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.

***

## 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

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

> [card] [FlowX Database](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/flowx-database.md)
>
> Collections, operations, and usage in workflows

> [card] [Oracle database](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/oracle-database.md)
>
> Add an Oracle data source and define queries

> [card] [PostgreSQL database](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/postgresql-database.md)
>
> Add a PostgreSQL data source and define queries

> [card] [Testing a knowledge base](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/knowledge-base-integration/testing-knowledge-base.md)
>
> The equivalent testing surface for knowledge bases


## Related topics

- [Builds](https://docs.flowx.ai/6.x/docs/projects/runtime/builds.md)
- [Choose how to connect FlowX.AI to external systems](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/integrations-overview.md)
- [MCP Data Sources](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/mcp-integration/adding-mcp-data-source.md)
- [SOAP System](https://docs.flowx.ai/6.x/docs/platform-deep-dive/integrations/soap-system.md)
- [Data mappers](https://docs.flowx.ai/6.x/docs/building-blocks/process/data-mappers.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.