How to Use

​

What is OptiDev Cloud

• Database - Store and organize your app’s data (user profiles, orders, messages, etc.)
• Authentication - Let users create accounts and log in securely
• Edge Functions - Run server-side code for things like payment processing or sending emails
• Secrets - Securely manage environment variables and API keys
• Storage - Store files like images, documents, and videos
• Advisors - Get security and performance recommendations

​

Works with OptiDev Agent

• “Create a table to store customer orders with name, email, and order total”
• “Add user login to my app”
• “Create an API endpoint that connects to Stripe for payments”
• “Set up file upload for profile pictures”

​

Activating OptiDev Cloud

​

Step 1: Open OptiDev Cloud

​

Step 2: Choose a Region

​

Step 3: Activate

​

The OptiDev Cloud Dashboard

​

Connection Info

• API URL - Your backend endpoint
• Publishable Key - Public API key for frontend code
• Database Connection - PostgreSQL connection strings in 9 formats
• Reset Password - Generate a new database password

​

Database

• Table List - See all your tables in the left sidebar (only public schema tables are shown)
• SQL Editor - Monaco-powered editor with syntax highlighting
• Click to Query - Click any table name to automatically populate SELECT * FROM table_name
• Query Results - View results in a table with row count display
• Schema Inspection - See column types, nullable status, and default values
• Export Data - Download results as CSV, JSON, or Excel

​

Auth

• Sign-in Providers - Enable Email, Phone (SMS), or Google authentication
• Auth Settings - Configure Site URL, allowed redirect URLs, and signup options
• User Signup Controls - Allow/disable new signups, enable anonymous users

​

Users

• User List - Search and browse all users with pagination
• Create Users - Manually create user accounts
• Invite Users - Send email invitations for self-registration
• Delete Users - Remove user accounts

​

Edge Functions

• Workspace Functions - Functions in your code, ready to deploy
• Deployed Functions - Functions running on OptiDev Cloud
• One-click Deploy - Deploy functions directly from the dashboard
• Testing Tools - Test functions with custom requests before connecting to your app

​

Secrets

• Write-Only Security - Secret values can never be retrieved after saving
• Bulk Operations - Add multiple secrets at once before saving
• Instant Access - Secrets are immediately available in Edge Functions via Deno.env.get()

​

Storage

• Create buckets with file size limits and MIME type restrictions
• Browse files with folder navigation
• Upload files directly from your computer
• View and manage Row Level Security (RLS) policies

​

Advisors

• Security checks - Missing Row Level Security, exposed data, weak access policies
• Performance checks - Missing indexes, slow queries, inefficient configurations
• Severity filtering - View by ERROR (critical), WARN (important), or INFO (suggestions)
• One-click remediation - Copy SQL fixes directly from issue details

​

Using OptiDev Agent with OptiDev Cloud

​

Creating Tables

“Create a products table with name, description, price, and image URL”

1. Create the table with the right column types
2. Set up the database schema
3. Show you the table in your dashboard

​

Adding Authentication

“Add user authentication to my app with email and Google sign-in”

1. Enable the auth providers
2. Add sign-in forms to your app
3. Connect everything together

​

Creating API Endpoints

“Create an API endpoint that accepts payment with Stripe and saves the order to the database”

1. Create an Edge Function with the Stripe integration
2. Deploy it to OptiDev Cloud
3. Connect it to your frontend

​

Working with Storage

“Add profile picture upload to user settings and display them next to usernames”

​

Managing Secrets

“Store my Stripe API key securely so I can use it in Edge Functions”

1. Create a secret with your API key
2. Update your Edge Function code to use Deno.env.get('STRIPE_API_KEY')
3. Ensure the secret is never exposed in your frontend

​

What OptiDev Agent Can Do

• Query database via PostgREST API
• Execute DDL SQL for schema changes and RLS policies

• List and manage authenticated users

• List deployed functions
• Deploy functions from workspace
• Get function source code

• List, create, update, and delete buckets
• Upload files with presigned URLs
• List and delete files
• Browse folders with prefix filtering

• List secrets (names and digests only)
• Create write-only secrets
• Delete secrets in bulk

• Fetch service logs (api, postgres, edge-function, auth, storage, realtime)
• Get security and performance advisor recommendations

• Get project info and activation status

• Request OptiDev Cloud activation with inline button in chat

​

Checking Your Data

​

Viewing Tables

1. Go to the Database tab
2. Click any table name in the left sidebar
3. Browse rows using the pagination controls at the bottom

​

Editing Data

• Double-click any cell to edit it
• Press Enter to save or Escape to cancel
• Click Add Row to create a new entry

​

Running Queries

SELECT * FROM orders WHERE total > 100

​

Viewing Users

1. Go to the Users tab
2. You’ll see a paginated list of all registered users
3. Each user shows:
   • Email address
   • When they signed up
   • Last sign-in time
   • Auth provider used (email, phone, or Google)

​

Monitoring Edge Functions

​

Viewing Deployed Functions

1. Go to the Edge Functions tab
2. Deployed Functions shows all functions running on OptiDev Cloud
3. Each function shows its name, version, and last update time

​

Function Details

• Function URL (for calling from your app)
• Execution history
• Recent invocations
• Version number

​

Testing Functions

1. Click Test next to any deployed function
2. Choose the HTTP method (GET, POST, PUT, PATCH, DELETE)
3. Add headers, query parameters, or request body data
4. Click Send Request to see the response

• Status code with color-coded badge
• Response body (formatted JSON)

​

For Developers

npm install @supabase/supabase-js

// OptiDev Agent handles this automatically
const { data, error } = await supabase.storage
  .from('avatars')
  .upload('user-123.jpg', file)