---
title: "FAQ, MCP & limits"
section: "Data Source"
description: "Answers to common questions about SmartestQA Data Source: sharing, secrets, environments, databases, networks, datasets; MCP tools; limits."
url: https://docs.smartestqa.ai/en/data-source-faq.html
audience: [customer, admin]
updated: 2026-11-08
keywords: "data source faq share projects encrypted admin see secret database types firewall agent dataset sheets mcp smartest_integrations limits"
---
# Data Source: FAQ, MCP & limits

Answers to common questions about Data Source, how AI assistants work with this module, and its limits.

## In short

**On this page you can**

- Find quick answers about sharing, secrets, environments and databases.
- See what an AI assistant can and cannot do with your data and connections.
- Check the module’s limits and timeouts.

**How to use it**

1. Filter the questions by your role with the chips.
2. Open a question; follow its link for the full procedure.
3. For AI work, connect an assistant and try the example prompts.
4. Keep the limits table in mind when you design data-driven tests.

## Questions and answers

### Q: Where do I put the password for a login test?

In an encrypted key, for example `adminPassword`. The Type step’s value is `{{ds:adminPassword}}`. See [Encrypt a value](https://docs.smartestqa.ai/en/data-source-secrets.html#encrypt).

_Audience: customer_

### Q: Can two projects share keys or connections?

No. Keys, datasets and connections belong to one project. Create them again in the other project; for datasets, upload the same file.

_Audience: customer, admin_

### Q: How do I use other data on TEST than on DEV?

Keep the default in `loginEmail` and add `loginEmail_TEST`. A TEST run uses the variant; steps keep `{{ds:loginEmail}}`. Datasets work the same way. See [Environment-specific keys](https://docs.smartestqa.ai/en/data-source-variables.html#environments).

_Audience: customer_

### Q: Can an Admin see an encrypted value?

No. Only the person who created it can show it. An [Admin](https://docs.smartestqa.ai/en/company-settings-roles.html) can replace it, and can delete the key. See [Who can see an encrypted value](https://docs.smartestqa.ai/en/data-source-secrets.html#who-sees-what).

_Audience: admin_

### Q: How are secrets stored on the server?

Encrypted keys, DB passwords, Kafka SASL passwords and API request passwords and tokens are stored with AES-256-GCM. On a self-hosted installation, the server needs the encryption key in `SMARTEST_ENCRYPTION_KEY`; without it these values are stored unencrypted. Ask info@smartestqa.ai if you are unsure how your installation is set up.

_Audience: admin_

### Q: Which databases can tests use?

A run reads the database type from the URL and connects to PostgreSQL (`jdbc:postgresql`), MySQL (`jdbc:mysql`) and Oracle (`jdbc:oracle`). For another database, write to info@smartestqa.ai before you build tests on it.

_Audience: customer, admin_

### Q: Our database is only reachable inside our network. Can we still use it?

Yes. Run the tests on [an agent](https://docs.smartestqa.ai/en/agent-pool-agents.html) or self-hosted runner inside the network: DB and Kafka connections are opened from the machine that runs the test. **Test Connection** will fail because it runs on the SmartestQA server; check with a [Dry Run](https://docs.smartestqa.ai/en/automate-dry-run.html) on the agent instead. See [Where connections are opened from](https://docs.smartestqa.ai/en/data-source-in-tests.html#where-it-connects).

_Audience: customer, admin_

### Q: Which addresses must our firewall allow?

For **Test Connection** and for runs on the server: the SmartestQA server. For runs on [an agent](https://docs.smartestqa.ai/en/agent-pool-agents.html): the agent’s machine. Ask info@smartestqa.ai for the current addresses of the SmartestQA servers.

_Audience: admin_

### Q: Can a test change data in the database?

Yes. [DB steps](https://docs.smartestqa.ai/en/automate-steps-database.html) and DB-bound keys accept INSERT, UPDATE, DELETE, DDL and procedure calls, and the changes are committed. Use a test database and a user with only the rights the tests need.

_Audience: customer_

### Q: My workbook has several sheets. Which one is used?

Only the first sheet. Save each sheet as its own file, or move it to the front, and upload one dataset per sheet.

_Audience: customer_

### Q: Does connecting an action to a key fill the action’s steps?

No. It tells SmartestQA and the AI which pages need which data. A step still needs `{{ds:key}}` as its value. See [Connected actions](https://docs.smartestqa.ai/en/data-source-variables.html#connected-actions).

_Audience: customer_

### Q: What happens to tests when a key is deleted?

They keep the reference and lose the value at run time. Search the tests for the key first. Only [Admins](https://docs.smartestqa.ai/en/company-settings-roles.html) can delete keys.

_Audience: customer, admin_

### Q: Does the AI see our test data?

The AI receives key names, their kind, description and whether they are encrypted, for the pages their connected actions belong to. It never receives key values. Encrypted values never leave the server except to the runner.

_Audience: admin_

### Q: Where do I set up the mailbox for OTP and email tests?

Not in Data Source: under **[Integrations](https://docs.smartestqa.ai/en/integrations.html)** (Email). Use a dedicated [test mailbox](https://docs.smartestqa.ai/en/integrations-email.html), never a person’s inbox.

_Audience: customer_

## For AI assistants (MCP)

An assistant connected through the SmartestQA MCP server works with this module through `smartest_integrations`:

| System | Actions |
| --- | --- |
| `jdbc` | `list` the DB connections (credentials masked), `usage`, `query` (read), `execute` (changes data, asks you first), `test` a saved connection |
| `kafka` | `list` the Kafka connections (credentials masked). Test them in the screen. |
| `excel` | `list`: datasets with their columns and row counts |
| `mail` | The [test mailbox](https://docs.smartestqa.ai/en/integrations-email.html) from Integrations: `messages`, `wait`, `otp`, `link` |

Connections and credentials are created only in the SmartestQA screen. When a scenario the assistant writes needs data, it creates the keys; a secret is created encrypted and empty, and you fill it in. Connect an assistant from **Device Farm** › **Test Agents** › [**Connect to Claude**](https://docs.smartestqa.ai/en/mcp-connect.html#claude-desktop); more in [Discover › MCP](https://docs.smartestqa.ai/en/discover-faq.html#mcp).

Example prompts

```text
List the DB connections of project "Web Shop" and which test cases use each one.

Check that the orders table on "Orders DB (TEST)" has a row with status NEW. Read only.

Which keys of project "Web Shop" have no value? Suggest what each should contain, but do not write any password.
```

## Limits

| Item | Limit |
| --- | --- |
| Key name | Unique in the project, no spaces |
| Value sources per key | 1 (typed, dataset cell or DB query) |
| Environments for variants | DEV, TEST, PRP (suffix `_DEV`, `_TEST`, `_PRP`) |
| Dataset and connection names | Unique in the project, case-sensitive |
| Dataset files | XLSX, XLS, CSV; first sheet only |
| Dataset editor | 50 rows per page |
| Kafka **Test Connection** | 5 seconds |
| Driver message after a failed DB test | 300 characters |
| [DB step](https://docs.smartestqa.ai/en/automate-steps-database.html) and DB-bound key query | 30 seconds |
| [Kafka Consume](https://docs.smartestqa.ai/en/automate-steps-kafka.html#consume) wait | 10 seconds default, 300 maximum |
| Masking in logs | Values of 3 characters or more |
| Sharing between projects | Not available |
