OPS
Operations desk
The overlapping desk: incidents, configuration, and the glue between teams. Built for the people who sit between titles.
1–24 / 1864
SQL Formatter / Beautifier
LiveFormat SQL with indentation and consistent keyword casing in the browser.
Open toolDev/Test Shutdown Schedule Savings Calculator
LiveEstimate savings from shutting down non-production resources outside business hours.
Open toolCloud Cost Estimator
LiveRough monthly estimate for compute, storage, and network using editable unit rates.
Open toolData Egress Cost Calculator
LiveEstimate data transfer (egress) costs across common cloud pricing bands.
Open toolSQL Query Explainer
LiveExplain what a SQL query does in plain English. The result stays on this page.
Open toolSQL JOIN Visualizer
LiveVisualize INNER/LEFT/RIGHT/FULL joins with sample data. The result stays on this page.
Open toolSQL Query Builder
LiveBuild SELECT queries from tables and columns visually. The result stays on this page.
Open toolWindow Function Builder
LiveBuild ROW_NUMBER, RANK, LAG/LEAD, running totals. The result stays on this page.
Open toolSQL Date Function Converter
LiveEquivalent date functions across databases. The result stays on this page.
Open toolFind Duplicates Query Generator
LiveGenerate queries to find/delete duplicate rows. The result stays on this page.
Open toolUpsert / MERGE Statement Generator
LiveGenerate INSERT ON CONFLICT / MERGE / ON DUPLICATE KEY. The result stays on this page.
Open toolIN List Generator
LiveTurn a column of values into a SQL IN list. The result stays on this page.
Open toolMySQL my.cnf Tuning Calculator
LiveSuggests buffer pool and key settings from RAM and workload. The result stays on this page.
Open toolPostgreSQL Config Tuner
LiveSuggests shared_buffers, work_mem etc. from hardware specs. The result stays on this page.
Open toolSQL Server Max Memory Calculator
LiveRecommends max server memory setting for SQL Server. The result stays on this page.
Open toolSQL Server MAXDOP Calculator
LiveRecommend MAXDOP and cost threshold for parallelism. The result stays on this page.
Open toolInnoDB Buffer Pool Calculator
LiveInnoDB Buffer Pool Calculator. Size innodb_buffer_pool and instances. The result stays on this page.
Open toolmysqldump / pg_dump Command Builder
LiveBuilds backup and restore commands with options. The result stays on this page.
Open toolDatabase Backup Strategy Planner
LivePlan full/differential/log backups by RPO/RTO. The result stays on this page.
Open toolSQL Server Maintenance Plan Generator
LiveGenerate backup/maintenance jobs (Ola Hallengren style). The result stays on this page.
Open toolGRANT Statement Builder
LiveBuild GRANT/REVOKE statements per engine. The result stays on this page.
Open toolpg_hba.conf Generator
LiveGenerate PostgreSQL client authentication rules. The result stays on this page.
Open toolCSV to SQL INSERT Generator
LiveConverts CSV data into INSERT statements. The result stays on this page.
Open toolJSON to SQL INSERT Generator
LiveConvert JSON arrays into INSERT statements. The result stays on this page.
Open toolGuides
Pillar guides for this desk. Published supporting pages are linked from the pillar they belong to.
SQL Query Tools
Schema Design & Modeling
Performance & Indexing
Configuration & Tuning
Backup & Recovery
Replication & High Availability
Database Security & Access
Data Import, Export & Conversion
Connections & Client Tools
Capacity, Sizing & Licensing
Monitoring & Diagnostics
Migration & Upgrades
NoSQL & Specialized Databases
Developer & ORM Utilities
AI, Vector & Analytics Databases
SQL Learning & Reference
Career & Certification
Database Engine Guides
- MySQL Administration Guide
- PostgreSQL Administration Guide
- SQL Server Administration Guide
- Oracle Database Administration Guide
- MariaDB Administration Guide
- IBM Db2 Administration Guide
- CockroachDB Administration Guide
- SQLite Administration Guide
- DuckDB Administration Guide
- ClickHouse Administration Guide
- MongoDB Administration Guide
- Redis Administration Guide
- Cassandra Administration Guide
- Elasticsearch Administration Guide
- Neo4j Administration Guide