5 prompts
Set up a [Supabase/Firebase] backend for [app]. Include the data model, authentication, row-level security or security rules so users only access their own data, example queries from the client, and storage for user uploads.
Sets up auth, database and security rules for a small app.
Design a GraphQL schema for [domain, e.g. a blog with posts, authors and comments]. Include types, queries with pagination, mutations, input types, and example resolvers in [language/framework]. Note how to avoid N+1 queries.
A GraphQL schema with queries, mutations and resolvers.
Act as a data analyst. Database: [PostgreSQL / BigQuery / Snowflake / MySQL] Tables: [users(id, created_at), events(user_id, event_name, created_at), orders(...)] Questions: [monthly cohort retention, weekly active users, sign-up to purchase funnel] Write the queries with CTEs and comments, explain each step, and desc…
Write analytics SQL for cohort retention, funnels and active users.
Act as an SEO analyst. Here is my Search Console export (queries/pages with clicks, impressions, CTR, position): [paste] Identify: keywords ranking 5–20 with high impressions, pages with low CTR for their position, cannibalisation (several pages for one query), and declining pages. For each opportunity, recommend a sp…
Find pages and keywords close to page one and improve them for fast traffic gains.
Act as a SQL expert. Database: [MySQL / PostgreSQL / SQLite / SQL Server] Tables: [table_name](column1 type, column2 type, ...) [table_name](...) What I want: [describe the result in plain English, e.g. "top 10 customers by total spend in 2025, with their order count"] Please: 1. Write the query with clear aliases and…
Describe the data you need in normal words and get a correct, readable SQL query with an explanation and performance tips.