| 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.