Database

All tools
List of tools tagged as Database
Area Code Lookup
Look up a NANP area code from a code, phone number or place and review assignment status, overlay context and official dialing evidence.
DB Replica Lag Catch-up Calculator
Estimate whether a database replica can drain its backlog within a target window, with retained-log risk and throttle or apply-boost scenarios.
Database Connection Pool Calculator
Size database connection pools across replicas and workers while checking reserve-aware headroom, rollout surge risk and per-holder caps.
Database Index Rollout Planner
Plan a database index rollout with engine-aware SQL and build estimates, then review risk and guardrails for validation and rollback.
Database Migration Risk Checker
Check SQL migration risk before release with engine and table context, exposing destructive changes plus lock hazards, rewrites and backfills.
Database Storage Growth Calculator
Forecast database storage runway from projected data growth, then include operational overhead and estimate threshold dates and monthly cost.
Google Professional Data Engineer Exam Prep
Planned independent v4.2 practice for designing, ingesting, processing, storing, analyzing, automating, and securing Google Cloud data.
Microsoft Azure Data Fundamentals Exam Prep
Practise DP-900 data concepts with 36 original questions, source-linked explanations and focused rounds across Azure data and analytics domains.
Microsoft Power BI Data Analyst Exam Prep
Practise PL-300 Power BI skills with 32 original questions, source-linked explanations and focused retries across four data analyst domains.
MySQL Slow Query Log Analyzer
Analyze MySQL slow query logs locally to group SQL fingerprints and rank accumulated or tail cost with scan, lock and temp-table findings.
NAICS Code Lookup
Find a 2022 NAICS code from an activity phrase or known code, compare ranked candidates and hierarchy paths, then verify the official definition.
PostgreSQL EXPLAIN Plan Analyzer
Inspect PostgreSQL EXPLAIN plans for costly nodes and row-estimate drift with browser-local parsing of scan, spill and buffer clues.
Postgres Work Mem Calculator
Size PostgreSQL work_mem from server RAM and active query demand with hash weighting, safety margins and scoped spill guidance.
Queue Worker Capacity Calculator
Size a queue worker pool from busy-period arrivals, measured throughput, backlog drain time, utilization headroom, and worker limits.
Redis Memory Size Calculator
Size Redis maxmemory, per-process host RAM, and replica capacity from measured key costs, growth headroom, buffers, and shard plans.
SQL Formatter
Format SQL in your browser with dialect-aware layout and an audit that flags fallback output, unbalanced parentheses, and risky reuse.
SQL Fundamentals Quiz
Practise SQL fundamentals with original query questions and explanations, then retry missed answers across portable SQL and PostgreSQL 18.
SQL INSERT Generator
Turn pasted rows or a local delimited file into reviewable SQL INSERT statements with dialect-aware identifiers, literal handling, and row checks.
SQL Schema Designer
Design and validate a relational schema locally before generating reviewed DDL for PostgreSQL, MySQL, or SQLite from one portable model.
SQL Validator
Check SQL structure and selected dialect rules for PostgreSQL, MySQL, or SQLite without connecting to a database or executing statements.
SQL to Java Entity Generator
Turn one MySQL or PostgreSQL CREATE TABLE statement into a reviewable Java persistence entity with explicit mapping choices and notes.
SQLite Manager
Open a SQLite file in your browser and inspect schema or rows before running guarded SQL and saving deliberate edits as a new local copy.