blink-app

name	blink-app
description	Read and write data in a linked Blink project's database and file storage. Use to manage app data, query users, update records, upload/download files. Requires BLINK_PROJECT_ID secret to be set first.
metadata	{"blink":{"requires_env":["BLINK_API_KEY","BLINK_AGENT_ID","BLINK_PROJECT_ID"]}}

Blink App — Project Database & Storage

Access a linked Blink project's isolated SQLite database and file storage using blink db and blink storage.

Setup (one-time)

Store your project ID as an agent secret:

blink secrets set BLINK_PROJECT_ID proj_xxx

Get your project ID from blink.new → your project → Settings → API Keys.

---

Database

Query the database

blink db query $BLINK_PROJECT_ID "SELECT * FROM users LIMIT 10"

Count records

blink db query $BLINK_PROJECT_ID "SELECT count(*) as total FROM orders WHERE status = 'pending'"

Insert a record

blink db query $BLINK_PROJECT_ID "INSERT INTO tasks (id, title, done) VALUES ('t_123', 'My task', 0)"

Execute a SQL file

blink db exec $BLINK_PROJECT_ID schema.sql

List all tables

blink db list $BLINK_PROJECT_ID

Show rows in a table

blink db list $BLINK_PROJECT_ID users

---

Storage

Upload a file

blink storage upload $BLINK_PROJECT_ID ./report.pdf --path reports/2024/report.pdf

List files

blink storage list $BLINK_PROJECT_ID
blink storage list $BLINK_PROJECT_ID images/

Get a public URL for a file

blink storage url $BLINK_PROJECT_ID images/logo.png

Download a file

blink storage download $BLINK_PROJECT_ID reports/2024/report.pdf ./local-report.pdf

Delete a file

blink storage delete $BLINK_PROJECT_ID old-file.pdf

---

Command signatures

blink db query <project_id> <sql>
blink db exec <project_id> <file.sql>
blink db list <project_id> [table]
blink storage upload <project_id> <local_file> [--path <storage_path>]
blink storage list <project_id> [prefix]
blink storage url <project_id> <storage_path>
blink storage download <project_id> <storage_path> [output_file]
blink storage delete <project_id> <storage_path>

All commands use $BLINK_PROJECT_ID from the agent secrets vault.