MySQL Variables icon

MySQL Variables

Store and read variables (cookies, API keys, client id/secret) in MySQL or embedded SQLite, with per-credential isolation and AES-256-GCM encryption

Get Variable

AI-generated

Summary

Read a variable from the configured MySQL or SQLite store by its key. Returns the decrypted value and its type, or can return a not-found result instead of raising an error.

Inputs

  • Key (required) — The variable key to look up; unique within the store.
  • Return Empty if Not Found — Defaults to false. When enabled, a missing key returns value: null and found: false; otherwise the operation raises an error.

Output shape

One output item per input item, containing a single JSON object.

For a found key, the object includes key, value, type, and found: true. JSON values are parsed into JSON; string values remain strings. When the key is missing and Return Empty if Not Found is enabled, the object contains key, value: null, and found: false (no type). Uses the required MySQL Variables credentials to connect to the configured store.

Links

Discussion