Search: "database-tuning"

#SQL #optimization #performance

Coding Advanced

SQL Query Optimizer

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

#data cleaning #csv #pandas

data Intermediate

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

#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...

#postgresql #indexing #performance

coding advanced

PostgreSQL Database Indexing Strategy for Slow Queries

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

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

coding advanced

Kubernetes Deployment Configuration: Production Best Practices Guide

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

#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:...

#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...

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

coding intermediate

Docker Containerization for Python Flask Applications

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

#coding #docker #python

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python

#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...

#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...

#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 ...

#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...

#sql migration prompt #rollback safe deployment #database schema change

coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

data advanced

ETL Pipeline Design for Data Warehouse

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

#data #etl #pipeline

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

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

#data #quality #assessment

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#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...

#SQL #GROUP BY #window functions

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

#Docker #Docker Compose #containers

Docker Compose: Multi-Service Application Setup and Configuration Guide

Help me set up a Docker Compose configuration for a multi-service application. I...