Shortcuts

The following shortcut actions are available in the Apple Shortcut application.

Shortcuts With Input CSV file

Create SQLite DB from CSV File

This Shortcut action requires a CVS text file as input and create a SQLite database as output.
Parameters like charset encoding, separator type and table name are available.

Shortcuts to Execute SQL Script

Execute SQLite Script with SQLite File

This Shortcut action requires a SQLite database file as input, the SQL statement and optionally named parameters.

• Named Parameters: can be used to specify some parameter in the SQL statement. E.g.:
  SQL:
  SELECT * FROM table1 WHERE field1 = :id
  This parameter can be linked to a variable of type Dictionary (from a previously defined Dictionary action), or directly using a JSON string, e.g.:
  { "id": "value1" } or { "id": 123 }

• Output file format: can vary depending on the type of SQL statement: query or update. In case of query statement, you can use: HTML, CSV, BLOB, SQLite (query output), NDJSON and JSON. In case of update statement, since the input database file won't be affected, you can use the output format: SQLite (full database) that return a copy of the input database file with the changes applied by the SQL statement.

• Enable history: enable trace in the App history of the statement execution.

Execute SQLite Script with DB Name

This Shortcut action requires the name of a database present in the application or an iCloud "SQLite Mobile" database, and the script name created in the application or directly the SQL statement.

• Script Name: the script name to execute, related to the database name and created in the application.
  Untitled script won't be visible here.
  If both script name and SQL statement is specified, only the script name is executed and the SQL statement is ignored.

• Named Parameters: can be used to specify some parameter in the SQL statement. E.g.:
  SQL:
  SELECT * FROM table1 WHERE field1 = :id
  This parameter can be linked to a variable of type Dictionary (from a previously defined Dictionary action), or directly using a JSON string, e.g.:
  { "id": "value1" } or { "id": 123 }

• Output file format: can vary depending on the type of SQL statement: query or update. In case of query statement, you can use: HTML, CSV, BLOB, SQLite (query output), NDJSON and JSON. In case of update statement, since the input database file won't be affected, you can use the output format: SQLite (full database) that return a copy of the input database file with the changes applied by the SQL statement.

• Enable history: enable trace in the App history of the statement execution.

Shortcuts for Local Database Files Management

Shortcuts that works with database files imported in the application or iCloud "SQLite Mobile" databases.

Add SQLite Database

This Shortcut action adds the input specified file in the application as local database, to be used by other Shortcuts or from the main app as well.

Get SQLite Database

This Shortcut action returns a copy of the specified local database present in the application.

Get Database List

This Shortcut action returns the name list of all local databases present in the application.

Shortcuts Utility

Function Generator

This Shortcut action generates values from functions like UUID, CUID or random string with a specific length.

Hex Encoder

This Shortcut action encodes a binary file into HEX string, useful for insert data into BLOB fields.

Shortcuts Remote Dictionary

iCloud remote dictionary, it is user based, iCloud synchronized and not related to the database files.

Check what is the remote dictionary.

Remote Dictionary

This Shortcut action returns the entire dictionary in JSON string format.

Remote Dictionary Get Value

This Shortcut action returns the value of the specified key.

Remote Dictionary Set Value

This Shortcut action sets a new value to the specified key.

Remote Dictionary Delete Value

This Shortcut action deletes the value of the specified key.

Remote Dictionary Replace

This Shortcut action replaces the entire dictionary with the new one specified.