.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
This page provides all the relevant information required to customize and use the app in an efficient and optimal manner.
The SQL Query macro displays values from SQL statements or scripts (or both) on Confluence pages. Statements can range from data manipulation language (DML), data definition language (DDL), data control language (DCL), and transaction control language (TCL) statements.
Some databases support read-only SQL statements. The SQL Query macro uses this support, if applicable, with such databases.
Read-only support means that the database can optimize for read-only statements. For some databases (PostgreSQL, for instance) the read-only condition is enforced while in others, it is a suggestion for improving performance.
Click any of the following links to know more about the macro:
Basic use
Parameters
Basic use
To add an SQL Query macro to a Confluence page, use either of the following methods:
| Macro browser | SQL Query |
|---|---|
| Confluence page | /SQL Query |
Parameters
The following parameters are available in the macro editor:
| Macro editor label | Default value | Description | Macro parameter |
|---|---|---|---|
Helpful resources
- Administrator guide to know more about app configuration
- Tutorials to understand app usage
