Debug or Explain a SQL Query
You are a senior SQL reviewer. I will give you a query that errors, runs slowly, or returns numbers I don't trust. SQL dialect: {{SQL_DIALECT}} The query: {{SQL_QUERY}} Schema notes (columns, keys, approximate table si…
A searchable database of 2,200+ ready-to-use AI prompts for ChatGPT, Claude and Gemini, sorted into categories. Know what you want? Try the AI prompt finder.
Share AI prompts instantly with secure, expiring links. Perfect for team collaboration.
Visual workflow editor for complex prompts with conditional logic and loops.
You are a senior SQL reviewer. I will give you a query that errors, runs slowly, or returns numbers I don't trust. SQL dialect: {{SQL_DIALECT}} The query: {{SQL_QUERY}} Schema notes (columns, keys, approximate table si…
You are a data analyst who writes clear, correct SQL and explains it. SQL dialect (PostgreSQL, MySQL, SQL Server, BigQuery, SQLite, Snowflake): {{SQL_DIALECT}} Table definitions: names, columns with types, keys, and ho…
Act as a programming tutor for a student. My code has a bug or an error message. Help me understand and fix it myself; don't hand me corrected code. Language, course level and what the assignment allows (for example "A…
You are an engineer who packages team know-how for AI agents. Turn a workflow I keep explaining into a reusable skill: a SKILL.md file with a name, a short description of when to use it, and step-by-step instructions an…
Act as a skeptical senior engineer reviewing a change written by an AI coding agent. Agent-written code has characteristic failure modes; check for those specifically, in addition to normal review. The task the agent w…
Act as a staff engineer writing the instruction file that AI coding agents read before working in a repository: AGENTS.md (read by many tools) or CLAUDE.md (Claude Code). Write it from facts about this repo, not generic…
You are a senior data engineer. Write a script that cleans and validates a messy file reproducibly, reporting every row it changes or rejects instead of silently "fixing" data. Language and allowed libraries (e.g. Pyth…
Act as a senior engineer who writes readable, safe regular expressions. Build a regex for my matching task and prove it with tests. Regex flavor or language (Python re, JavaScript, PCRE, Go RE2, POSIX grep): {{REGEX_FL…
You are a senior engineer who ships schema changes to live systems without downtime. Plan this migration using the expand-and-contract approach. Database and how migrations are run (tool, deploy process): {{DIALECT}} T…
Act as a senior engineer designing a relational schema. Design the tables for this feature, and show me the decisions you're making so I can challenge them. Database: {{DIALECT}} Feature and the main things users do wi…
You are a database performance specialist. Diagnose this slow query from its execution plan and propose the smallest effective fix. Database and version: {{DIALECT}} The query: {{QUERY}} EXPLAIN (ANALYZE if possible) o…
Act as a senior data engineer who writes correct, readable SQL. Write a query that answers my question against this schema. SQL dialect and version (PostgreSQL 16, MySQL 8, SQLite, SQL Server, BigQuery, Snowflake…): {{…
You are a senior engineer reviewing a test suite with a mutation-testing mindset: for each test, would it fail if the code were wrong? Language and framework: {{LANGUAGE}} / {{TEST_FRAMEWORK}} The tests: {{TESTS}} The …
Act as a senior {{LANGUAGE}} engineer who writes fast, reliable tests. Help me test code that depends on things I don't control: the clock, HTTP APIs, a database, the file system or randomness. Test framework: {{TEST_F…
You are a senior engineer about to change legacy code that has no tests. Write characterization tests that pin down what it does today, right or wrong, so any change in behavior shows up. Language and test framework: {…
Act as a senior engineer experienced with property-based testing (Hypothesis for Python, fast-check for JavaScript and TypeScript, or the equivalent for {{LANGUAGE}}). Write property tests that check rules which must ho…
You are an adversarial tester whose job is to break code. Find the inputs most likely to make this code crash, hang or quietly return the wrong answer. Language: {{LANGUAGE}} Code: {{CODE}} Where its input comes from (…
Act as a senior test engineer. Write unit tests for this code by systematically choosing inputs, not by guessing a few happy paths. Language and test framework: {{LANGUAGE}} / {{TEST_FRAMEWORK}} Code under test: {{CODE…
You are a senior engineer fluent in both {{SOURCE_LANGUAGE}} and {{LANGUAGE}}. Port this code faithfully, so that it behaves the same, and write idiomatic {{LANGUAGE}}, not a line-by-line transliteration. Source code: …
Act as a senior engineer leading a major-version upgrade. Build me a step-by-step upgrade plan from the official migration notes and our code. Package or framework, current version and target version: {{UPGRADE}} The o…
You are a performance engineer. Optimize this code based on profiler data, not intuition. Language / runtime: {{LANGUAGE}} Profiler output (cProfile, py-spy, Chrome DevTools, pprof, perf, or similar), top entries: {{PR…
Act as a senior engineer cleaning up a codebase. I want to delete code that's no longer used, without deleting anything that's quietly still needed. Language / framework: {{FRAMEWORK}} The code, flags or endpoints I su…
You are a senior {{LANGUAGE}} engineer. This function is too long to understand or test. Break it up while keeping its observable behavior exactly the same. The function and any helpers it uses: {{LONG_FUNCTION}} How i…
Act as a senior {{LANGUAGE}} engineer who refactors production code without breaking it. Plan this refactor as small, safe, separately mergeable steps. The code to refactor: {{CODE}} What's wrong with it today (hard to…
Act as a senior platform engineer reviewing build and delivery configuration. Review this file for correctness, security, speed and reproducibility. File type and platform (GitHub Actions, GitLab CI, Jenkinsfile, Docke…
Ship better work in less time. Higher limits, no ads, no roadblocks.