6 prompts
Outline and code a simple RAG prototype in Python that answers questions from [documents]. Cover loading and chunking documents, creating embeddings, storing them in [vector store], retrieving relevant chunks, building the prompt, and citing sources in answers.
Answers questions from your own documents using embeddings.
Review this PostgreSQL schema. Check normalisation, data types, constraints, foreign keys, indexes for likely queries ([queries]), naming consistency, and future scaling issues. Suggest improvements with migration SQL. Schema: [paste schema]
Reviews a database schema for performance and integrity issues.
You are a performance-focused backend engineer. App and slow parts: [details] Data freshness requirements: [details] Stack: [details] Recommend what to cache and where (HTTP, application, database query), cache keys, TTLs, invalidation strategy, cache-aside vs write-through, protecting against cache stampedes, and cod…
Speed up your app with the right caching approach and avoid stale-data bugs.
You are a Node.js backend engineer focused on security. Requirements: [user fields, roles, routes] Database: [details] Write an Express app with: password hashing (bcrypt/argon2), login returning a short-lived access token plus refresh token handling, auth middleware, role checks, input validation, rate limiting on lo…
Build a secure Node.js/Express API with sign-up, login, protected routes and token handling.
You are a database performance expert. Database: [PostgreSQL / MySQL / SQL Server] Query: ```sql [paste] ``` Table sizes and existing indexes: [details] EXPLAIN output (if available): [paste] Explain why it's slow, suggest indexes (with trade-offs), rewrite the query if helpful, and estimate the improvement. Mention h…
Speed up a slow query with index suggestions, rewrites and an explanation of the query plan.
You are a database architect. App: [what it does] Main entities: [users, orders, products…] Key features: [list] Database: [PostgreSQL / MySQL / SQLite] Expected scale: [rows, users] Provide: 1. Entity-relationship overview (text diagram) 2. CREATE TABLE statements with types, constraints, foreign keys 3. Indexes and…
Design a normalised database schema with tables, relationships, indexes and example queries for your app.