Quick Start — SQL

One of the five Orvanta Quick Starts shown on an empty workspace’s Home page. Picking the Hello Orvanta (SQL) card opens this script as an unsaved draft in the script editor — nothing is deployed until you save it.

What it demonstrates

This is the one Quick Start that talks to a real database, so it’s the one that needs a little setup. Orvanta infers a SQL script’s arguments from -- $1 name (type) = default declaration comments in the file:

-- $1 name (text) = 'Orvanta'
SELECT 'Hello, ' || $1::text ||
       '! This ran as a SQL (PostgreSQL) script on Orvanta.' AS message;

The draft’s input form includes a database field asking you to pick a PostgreSQL resource to run the query against — every other Quick Start needs no setup at all; this one does, because it genuinely queries a database.

Try it

1. Open an empty workspace’s Home page and click Hello Orvanta (SQL) under Orvanta Quick Starts.
2. Pick (or create) a PostgreSQL resource in the database field.
3. Press Run to execute it.
4. Click Deploy if you want to keep it in the workspace — otherwise navigate away and the draft is discarded.

What next?

• SQL Quickstart — the full walkthrough of connecting Orvanta to a database and writing SQL scripts.
• Resources — how resources (like a PostgreSQL connection) work.
• Seed your workspace — back to the full Quick Starts gallery.