Every premium and members-only resource for $9.99/month, as a no-commitment subscription. See the plans

PalateKit

Sign in
Menu

Request a resource

Describe the resource you are missing in one sentence. We will email you when it is published.

0 / 280

A page, a video or an image online.

Unlock PalateKit

Unlock everything

Plan

Paying means accepting our terms of sale.

Secure payment by Stripe. Receipts and invoices sent by email.

Welcome back

Sign in to install, download or save this resource. A free account is enough for free resources.

Build and optimise a SQL query v1.0.0

Use this resource to write or optimise a SQL query

New

  • 201 downloads
  • 222 likes
  • 110 saves

Free

Install with the CLI

In a terminal, from the folder you want:

npx --yes palatekit@latest install sql-query-builder-and-optimiser

First time: connect the CLI with

npx --yes palatekit@latest login

The prompt has the assistant analyse the schema, data volumes and performance goal, then propose a query or an optimised version, with useful indexes. It also flags security points such as parameterising user input.

Mostly picked by

Updated November 2, 2026

Card for the “Build and optimise a SQL query” prompt

Details

Works in
Install guides
Generates with
Your agent's model
Licence
CC0-1.0

Similar resources

View all

What you get

  • The full prompt, ready to paste
  • Fields to fill in: SQL engine, version and data volumes
  • A step-by-step approach, from the brief to the query

Good fit for

  • Speeding up a slow query on PostgreSQL or MySQL
  • Writing a report query on an existing schema

Not for

    Tags

    • sql
    • optimisation
    • database

    About

    You say

    “Optimise this PostgreSQL 15 query that joins three order tables and sorts by date.”

    Card for the “Build and optimise a SQL query” prompt

    Prompt published by sivasaiyadav8143 under the CC0-1.0 license, delivered in its original version.

    Show more

    How to use it

    1. Paste the prompt into your assistant or agent
    2. Ask it to write or optimise a SQL query
    3. Review and adjust the result

    Content preview

    Files

    • LICENSE0.6 KB
    • NOTICE-PALATEKIT.md0.5 KB
    • sql-query-builder-and-optimiser.md9.2 KB

    Origin and licence

    Listed unmodified

    Author
    sivasaiyadav8143
    Source
    github.com/f/prompts.chat/blob/cecef6fc73c2c389770695a56252d331981727de/prompts.csv
    Licence
    CC0-1.0

    Notice

    « SQL Query Builder & Optimiser » (sivasaiyadav8143, CC0-1.0) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.

    User reviews

    –

    No ratings yet

    Loading reviews…

    Delete your review?

    Your rating and comment will be removed from the page.