> For the complete documentation index, see [llms.txt](https://gebra-it.gitbook.io/wiki/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gebra-it.gitbook.io/wiki/configuration/apps/stdsqleditor.md).

# StdSqlEditor

### SQL Statements

This app allows you to store SQL statements that can be used in all the apps of a workspace.

In the main editor window you can edit the SQL statement. It is always good practice to add a brief description for your statement. This description is searchable within the statement list.

In addition test parameter can be supplied. Test parameter must use Json format.

### Example Usages

```sql
select * from ExampleDataBase where ExampleCountryCode = @country and ExampleZipCode = @zip
```

\
Test parameter for the above statement

```sql
{"zip":"12345", "country":"DE"}
```

### Demo

{% embed url="<https://youtu.be/vs3uR5BRPKU>" %}