SQL Query Builder

Fill this prompt

Constructs optimized SQL queries based on natural language requirements.

Prompt Template

Act as a senior database administrator. Write a SQL query for {{Database: PostgreSQL, MySQL, SQLite, Oracle, SQL Server}}. Context/Schema: {{Schema: if used in an AI agent use the current project}}. Goal: {{Goal: e.g. Find all users who signed up in the last 30 days}}. Optimize for performance.

Prompt Guide

Best For

  • Starting from a structured, reusable prompt instead of a blank chat.
  • Adapting the prompt to your own inputs while keeping the original intent intact.
  • Workflows related to Data & Excel.

How To Use It

  1. Copy the full prompt template.
  2. Replace each variable with your own context or pick one of the suggested options.
  3. Paste the completed prompt into ChatGPT, Claude, Gemini, or another AI assistant.

Variables In This Prompt

Database

PostgreSQL, MySQL, SQLite, Oracle, SQL Server

Schema

if used in an AI agent use the current project

Goal

e.g. Find all users who signed up in the last 30 days

Example Starting Point

Act as a senior database administrator. Write a SQL query for PostgreSQL. Context/Schema: if used in an AI agent use the current project. Goal: e.g. Find all users who signed up in the last 30 days. Optimize for performance.

How Variables Work

Variable Syntax

Variables are wrapped in {{ and }} and follow this pattern:

{{variable name: option1, option2, option3 }}

Predefined Variables

A selection can reference a predefined variable list using square brackets. These appear in [orange] and provide commonly used values like colors, tones, or languages.

{{Tone: [tones] }}

Custom Selection Lists

You can also provide an inline list of choices separated by commas.

{{Format: bullet points, paragraphs, numbered list }}
💡

Tip: You don't need the PUCO app to use these prompts! Simply copy the template and replace each {{…}} section with your own text directly in ChatGPT, Claude, Gemini, or any other AI assistant.

Use this prompt in seconds — not minutes

Install PUCO for Mac: press a hotkey in any app, fill a smart form, paste into ChatGPT, Claude or Gemini. Every variable becomes a curated dropdown. Your last values are remembered.

Download on the Mac App Store