Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Analyze [SQL], [schema], and [query plan] to identify dominant work before proposing changes. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Compare estimated and actual rows where supplied. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1902
Choose an index for a real workload
/coding-choose-an-index-for-a-real-workload
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Propose an index for [queries] using [cardinality] and [write frequency] rather than indexing every column. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check ordering, selectivity, and write/storage tradeoffs. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1903
Remove an N-plus-one database pattern
/coding-remove-an-n-plus-one-database-pattern
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Review [fetch loop] and batch related reads while preserving ordering and access checks. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Compare query count and output shape for empty and populated results. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Plan [column change] using expand, backfill, and contract phases appropriate to [database]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check old and new application versions during overlap. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Implement [uniqueness rule] using database constraints and precise conflict handling. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check simultaneous attempts and transaction rollback. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1906
Resolve a transaction boundary problem
/coding-resolve-a-transaction-boundary-problem
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Map [multi-step write] and [consistency rule] to an appropriate transaction scope. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check intermediate failure and concurrent visibility. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1907
Handle soft-deleted rows consistently
/coding-handle-soft-deleted-rows-consistently
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Audit [queries] against [soft-delete rules], including joins and unique constraints. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check retrieval, restoration, and duplicate creation cases. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1908
Build a deterministic top-N query
/coding-build-a-deterministic-top-n-query
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Create [top-N report] with explicit tie-breaking and [filter rules]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check ties, null values, and repeatable ordering. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Compare [summary query] and [detail rows] using [grouping and rounding rules]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Flag mismatched filters and join multiplication. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1910
Repair a many-to-many join duplication
/coding-repair-a-many-to-many-join-duplication
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Analyze [join query] and [relationships] to prevent duplicated domain results. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check cardinality before using DISTINCT as a remedy. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1911
Implement keyset pagination in SQL
/coding-implement-keyset-pagination-in-sql
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Write keyset pagination for [sort columns] with a stable unique tie-breaker. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check first page, ties, and reverse ordering if required. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1912
Plan a large backfill in small batches
/coding-plan-a-large-backfill-in-small-batches
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Design a resumable backfill for [table] using [available key] and [load limits]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check checkpoints, idempotency, and safe stopping conditions. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1913
Explain database deadlock evidence
/coding-explain-database-deadlock-evidence
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Analyze [deadlock graph] and [transactions] to identify conflicting lock order. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Propose narrow ordering changes and bounded retry where appropriate. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1914
Choose isolation for a stated invariant
/coding-choose-isolation-for-a-stated-invariant
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Compare available isolation behaviors for [business invariant] in [database version]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Use a concurrent timeline to expose relevant anomalies. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1915
Create a read-only data-quality audit
/coding-create-a-read-only-data-quality-audit
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Write queries for [data-quality rules] with counts and sample record identifiers. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Ensure checks do not update or delete records. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Replace ambiguous date filtering in [report] with [timezone and inclusive/exclusive rules]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check month-end, leap dates, and boundary timestamps. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Model [relationship] with [tenant or domain keys] and appropriate foreign-key constraints. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check orphan prevention and update/delete rules. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Reconcile [export A] and [export B] using [key rules] and field-level differences. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Separate missing, added, duplicate, and changed records. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1919
Plan a database backup restore check
/coding-plan-a-database-backup-restore-check
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Draft a disposable restore verification for [backup format] and [recovery objectives]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check integrity, key records, permissions, and measured recovery time if executed. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Database version, schema, query aur chhota sample data dein. Tabdeeli pehle disposable database mein check karein aur asal data ka backup rakhein.
Databases & SQL
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Review [query] and [column types] for conversions that change results or index use. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check leading zeros, nulls, and malformed values. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1921
Stop a mutable default from leaking state
/coding-stop-a-mutable-default-from-leaking-state
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Fix [Python function] that uses a mutable default while preserving its public behavior. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check independent calls and explicit caller-provided containers. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Refactor [file-handling code] into bounded context-managed ownership. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check parse failures and early returns release the file. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1923
Replace a broad Python exception handler
/coding-replace-a-broad-python-exception-handler
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Narrow [except block] to documented expected failures and preserve unexpected exceptions. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check useful error context and original traceback propagation. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1924
Make an iterator safe for one-pass input
/coding-make-an-iterator-safe-for-one-pass-input
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Adapt [function] to consume [iterator] only as required without accidentally exhausting it twice. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check generators, empty inputs, and large streams. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1925
Parse CSV with explicit dialect rules
/coding-parse-csv-with-explicit-dialect-rules
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Write a reader for [CSV samples] using [delimiter, quoting, encoding, and null rules]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check embedded newlines, quoted delimiters, and incomplete rows. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Design [dataclass] creation from [external payload] without treating type hints as runtime validation. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check missing fields and invalid nested values. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1927
Convert a blocking call in async code
/coding-convert-a-blocking-call-in-async-code
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Review [async function] and isolate [blocking operation] using [available runtime facilities]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check cancellation, thread safety, and event-loop responsiveness. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Implement [decimal calculation] under [precision and rounding policy] without mixing binary floats. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check midpoint rounding and repeated accumulation. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1929
Package a small Python command-line tool
/coding-package-a-small-python-command-line-tool
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Create a minimal package and command entry point for [existing script] under [supported Python versions]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check install, help text, exit codes, and one representative invocation. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1930
Validate a Python CLI argument contract
/coding-validate-a-python-cli-argument-contract
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Implement [CLI options] with clear mutual exclusions, defaults, and input errors. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check help output, invalid combinations, and missing arguments. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Refactor [path code] to pathlib while preserving [platform requirements] and base-directory behavior. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check spaces, relative paths, and missing parents. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1932
Make imports work in an installed package
/coding-make-imports-work-in-an-installed-package
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Diagnose [import error] using [project tree] and [launch method]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check package imports without relying on the current working directory. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1933
Add typing to a public Python function
/coding-add-typing-to-a-public-python-function
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Type [function] and its inputs accurately under [type checker/version] without changing runtime behavior. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check optional values and realistic callers. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1934
Stream a large JSON-lines file
/coding-stream-a-large-json-lines-file
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Implement line-by-line processing of [JSONL file] with [error policy] and bounded memory. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check invalid lines, empty files, and preserved line numbers. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1935
Use a process pool for CPU work
/coding-use-a-process-pool-for-cpu-work
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Adapt [CPU-bound task] with [process limits] and serializable arguments. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check result ordering, worker failures, and platform startup requirements. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1936
Control Python logging configuration once
/coding-control-python-logging-configuration-once
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Repair [logging setup] to avoid duplicate handlers and preserve library/application boundaries. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check repeated initialization and parent logger propagation. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1937
Write atomic output with a temporary file
/coding-write-atomic-output-with-a-temporary-file
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Implement [file output] via a same-directory temporary file and suitable replace operation. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check interrupted writes and cleanup without overwriting unintended paths. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Add bounded caching to [pure function] using stable keys and [memory constraints]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check mutable inputs, invalidation needs, and cache growth. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1939
Safely load structured configuration
/coding-safely-load-structured-configuration
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Parse [YAML or JSON configuration] using [approved library] and explicit schema validation. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check untrusted constructs, invalid types, and useful location errors. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Python version, relevant function aur input/output ka example dein. Proposed code ko apne environment mein run karke result aur failure cases dekhein.
Python Engineering
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Analyze [profile output] and propose the smallest optimization to [hot function]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Separate measured bottlenecks from guesses and compare equivalent outputs. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Repair [promise chain] so expected failures are handled and unexpected failures remain visible. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check asynchronous rejection and synchronous exceptions separately. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Fix [JavaScript defaulting logic] without discarding valid zero, false, or empty-string inputs. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Compare null, undefined, and each valid falsy value. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1943
Narrow a union without unsafe assertions
/coding-narrow-a-union-without-unsafe-assertions
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Improve [TypeScript union handling] using explicit discriminants or supported runtime checks. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check exhaustive branches and invalid external input. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Build a small validator and typed result for [external JSON samples] under [TypeScript version]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Do not treat a type assertion as runtime proof. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Analyze [handler code] and [state update sequence] to identify captured stale values. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check rapid updates and cleanup after unmount or disposal. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1946
Avoid mutating an input array
/coding-avoid-mutating-an-input-array
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Refactor [array operation] to preserve [caller input contract] while keeping ordering semantics. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check nested references and empty arrays. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1947
Debounce a search request predictably
/coding-debounce-a-search-request-predictably
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Implement debounce for [search handler] with [delay] and cancellation of superseded work. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check clearing input, rapid changes, and late responses. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1948
Throttle a frequently fired event
/coding-throttle-a-frequently-fired-event
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Add throttling to [event handler] with explicit leading/trailing behavior. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check final event delivery and cleanup. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1949
Compare dates without parsing ambiguity
/coding-compare-dates-without-parsing-ambiguity
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Repair [date code] using [input format] and [timezone rules]. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check invalid strings and date-only versus timestamp meaning. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.
Draft prompt · not tested in each AI tool
#1950
Handle large integer identifiers safely
/coding-handle-large-integer-identifiers-safely
Runtime ya framework version ke saath relevant code aur observed behavior dein. Type-check aur target runtime ki jaanch alag record karein.
JavaScript & TypeScript
Full English prompt
Work from [relevant source/files], [language/runtime/framework versions], and [required behavior or constraints]. Ask only for missing information that affects correctness; otherwise state a limited assumption. Preserve [identifier samples] through parse, storage, and serialization without numeric precision loss. Preserve existing behavior outside the requested scope and prefer the smallest necessary edit. Return the concrete deliverable this task requires (patch, query, example, checklist, or plan), a brief reason, and verification evidence or steps. Check values beyond the supported number precision range. Distinguish proposed checks from actually executed checks; never invent successful runs. Use sanitized examples and placeholders for credentials or private data.