# ConnectionEditor

The connection string specifies the configuration values required to connect to the SQLite database.

To access the **Connection Editor**, click the **...** icon in the Connection string property.

<div align="left"><img src="/files/FUz4n8h4TWmevfdBZPXY" alt="Connection Editor"></div>

<div align="left"><img src="/files/6ry0viI6vwpRD37lrTFD" alt="Connection Editor"></div>

{% hint style="info" %}
**Note**

* The Connection Editor builds the connection string using a form with the most common properties pre-populated.
* You can add, remove, or rename properties directly in the form.
* Paste an existing connection string into the property field before opening the editor to have it parsed automatically.
  {% endhint %}

Once your connection is set up, you can create and execute SQL queries. See the [SQL Editor](/reference/plugins/database/shared-properties/sql-editor.md) for details.

## Connection string

`Data Source=C:\Data\myapp.db`

| Keyword       | Values                                               | Default           | Description                                                              |
| ------------- | ---------------------------------------------------- | ----------------- | ------------------------------------------------------------------------ |
| `Data Source` | File path or `:memory:`                              | *(required)*      | Absolute path to the `.db` file, or `:memory:` for an in-memory database |
| `Mode`        | `ReadWriteCreate`, `ReadWrite`, `ReadOnly`, `Memory` | `ReadWriteCreate` | Controls how the database file is opened                                 |
| `Cache`       | `Default`, `Private`, `Shared`                       | `Default`         | Enables connection sharing for in-memory databases                       |
| `Timeout`     | Integer (seconds)                                    | `30`              | Maximum time to wait if the database is locked                           |
| `Password`    | Any string                                           | *(none)*          | Requires a SQLCipher-compatible library                                  |

{% hint style="warning" %}
Always use absolute paths in `Data Source` (e.g. `C:\Data\myapp.db`). Relative paths are not supported.
{% endhint %}

<div align="left"><img src="/files/KnbmnTLrmRvUjfrrhEie" alt="SQLite connection string example"></div>

## Links

* [SQLite connection strings](https://www.connectionstrings.com/sqlite/)
* [Microsoft.Data.Sqlite connection string reference](https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/connection-strings)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.linx.software/reference/plugins/sqlite/common/connectioneditor.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.