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