OPS
运维桌
共享的书桌：故障、配置，以及团队之间的粘合。给坐在头衔之间的人。
1–24 / 1864
SQL Formatter / Beautifier
已上线Format SQL with indentation and consistent keyword casing in the browser.
打开工具Dev/Test Shutdown Schedule Savings Calculator
已上线Estimate savings from shutting down non-production resources outside business hours.
打开工具Cloud Cost Estimator
已上线Rough monthly estimate for compute, storage, and network using editable unit rates.
打开工具Data Egress Cost Calculator
已上线Estimate data transfer (egress) costs across common cloud pricing bands.
打开工具SQL Query Explainer
已上线Explain what a SQL query does in plain English. The result stays on this page.
打开工具SQL JOIN Visualizer
已上线Visualize INNER/LEFT/RIGHT/FULL joins with sample data. The result stays on this page.
打开工具SQL Query Builder
已上线Build SELECT queries from tables and columns visually. The result stays on this page.
打开工具Window Function Builder
已上线Build ROW_NUMBER, RANK, LAG/LEAD, running totals. The result stays on this page.
打开工具SQL Date Function Converter
已上线Equivalent date functions across databases. The result stays on this page.
打开工具Find Duplicates Query Generator
已上线Generate queries to find/delete duplicate rows. The result stays on this page.
打开工具Upsert / MERGE Statement Generator
已上线Generate INSERT ON CONFLICT / MERGE / ON DUPLICATE KEY. The result stays on this page.
打开工具IN List Generator
已上线Turn a column of values into a SQL IN list. The result stays on this page.
打开工具MySQL my.cnf Tuning Calculator
已上线Suggests buffer pool and key settings from RAM and workload. The result stays on this page.
打开工具PostgreSQL Config Tuner
已上线Suggests shared_buffers, work_mem etc. from hardware specs. The result stays on this page.
打开工具SQL Server Max Memory Calculator
已上线Recommends max server memory setting for SQL Server. The result stays on this page.
打开工具SQL Server MAXDOP Calculator
已上线Recommend MAXDOP and cost threshold for parallelism. The result stays on this page.
打开工具InnoDB Buffer Pool Calculator
已上线InnoDB Buffer Pool Calculator. Size innodb_buffer_pool and instances. The result stays on this page.
打开工具mysqldump / pg_dump Command Builder
已上线Builds backup and restore commands with options. The result stays on this page.
打开工具Database Backup Strategy Planner
已上线Plan full/differential/log backups by RPO/RTO. The result stays on this page.
打开工具SQL Server Maintenance Plan Generator
已上线Generate backup/maintenance jobs (Ola Hallengren style). The result stays on this page.
打开工具GRANT Statement Builder
已上线Build GRANT/REVOKE statements per engine. The result stays on this page.
打开工具pg_hba.conf Generator
已上线Generate PostgreSQL client authentication rules. The result stays on this page.
打开工具CSV to SQL INSERT Generator
已上线Converts CSV data into INSERT statements. The result stays on this page.
打开工具JSON to SQL INSERT Generator
已上线Convert JSON arrays into INSERT statements. The result stays on this page.
打开工具指南
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