Search: "database-tuning"

#sql review #board reporting #metric qa

data Advanced

ChatGPT Prompt for SQL Query Review Before Sharing a Board Report

Review my SQL query before I use it in an executive or board report where mistak...

#SQL #optimization #performance

Coding Advanced

SQL Query Optimizer

Analyze this SQL query for performance issues: [QUERY]. Provide: execution plan ...

#coding #sql #stored-procedure

SQL Stored Procedure for Data Transformation

Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...

data advanced

ETL Pipeline Design for Data Warehouse

Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...

#data #etl #pipeline

coding Advanced

SQL Query Optimization for Slow Database Queries

Help me optimize this slow SQL query: [paste your query]. The database is [MySQL...

#coding #sql #database

#database design #SQL #schema

Database Schema Design E-Commerce Platform

Design a normalized relational database schema for a multi-vendor e-commerce pla...

coding intermediate

Docker Containerization for Python Flask Applications

You are a DevOps engineer specializing in containerization. I need to containeri...

#coding #docker #python

#database migration #schema change #postgres

coding Advanced

ChatGPT Prompt: Database Migration Plan with Rollback Strategy

Design a safe database migration plan for [SCHEMA CHANGE]. Details: - Database:...

#Docker #Docker Compose #local development

Docker and Docker Compose Setup for Local Development Environment

Create a complete Docker and Docker Compose configuration for a local developmen...

👁 17 views

#coding #database #migration

Write a Migration Script That Can Be Re-run Safely

Act as a database engineer. I need a migration script that can be re-run safely ...

👁 17 views

#python #web scraping #beautifulsoup

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...

#coding #docker #docker-compose

Docker Compose Setup for Full-Stack Application

Write a complete docker-compose.yml for a full-stack application with the follow...

productivity Intermediate

Notion Workspace Setup for Second Brain System

Design a complete Notion workspace structure to implement a "Second Brain" perso...

#productivity #notion #second brain

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

#postgresql #indexing #performance

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema a...

excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

#SQL optimization #query performance #database

data Advanced

SQL Query Optimization Guide for Slow Database Queries

Analyze and optimize the following slow SQL query that is causing performance is...

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration

#CI/CD #GitHub Actions #deployment

coding Advanced

CI/CD Pipeline Configuration with GitHub Actions

Create a complete CI/CD pipeline using GitHub Actions for my project: - Project...

#Python #web scraping #BeautifulSoup

coding intermediate

Python Web Scraping: BeautifulSoup & Requests Data Extraction

Help me write a Python web scraper to extract [type of data] from [website descr...

data intermediate

SQL Query Builder for Complex Analytics

Help me write an optimized SQL query for my analytics need. Database details: D...

#data #sql #analytics

#kubernetes #k8s #deployment

Kubernetes Deployment Configuration: Production Best Practices Guide

Help me create a production-ready Kubernetes deployment configuration. My applic...

#coding #test-data #fixtures

Generate Realistic Test Fixtures from a Schema

I'll paste a database schema. Generate realistic test fixtures: 10-20 rows per t...