Tools for Database Administrators

BY TOOLS.FUN  ·  MARCH 28, 2026  ·  4 min read

Database administrators work across schema design, query optimisation, data migration, and incident triage. Between decoding a hex rowid, validating a JSON column, cleaning a duplicate list, or comparing two schema versions, there's a constant need for quick browser tools that don't require a SQL console or a Python session. Here are the Tools.Fun utilities that fit a DBA's workflow.

JSON Formatter & Validator

Validate and format JSON stored in JSONB or JSON columns (PostgreSQL, MySQL 5.7+, SQLite). Pretty-print dense payloads from query results to inspect nested structures, verify schema conformance, and diagnose malformed records that cause extraction errors.

Timestamp Converter

Convert Unix epoch values to human-readable dates and back — critical when working with databases that store timestamps as integers (SQLite, some MySQL setups, event-sourced tables). Generate epoch values for WHERE created_at > ? queries without mental arithmetic.

Code & Schema Diff Tool

Compare two versions of a CREATE TABLE statement, stored procedure, migration file, or query side by side. Instantly see what changed between schema versions during code review, audit trails, and rollback planning.

Duplicate Line Counter & Remover

Paste a list of IDs, email addresses, usernames, or foreign key values and instantly find or remove duplicates. Faster than SELECT COUNT(*), col FROM table GROUP BY col HAVING COUNT(*) > 1 for a quick spot-check on exported data.

Character Counter

Count characters and bytes for text values to validate they fit within column constraints — VARCHAR(255), CHAR(10), database-specific byte limits — before bulk insert or migration. Critical for multi-byte Unicode strings where character count differs from byte count.

RegExp Tester

Build and test the regex patterns used in REGEXP / SIMILAR TO queries, CHECK constraints, and stored procedure validation logic. Test against real sample data before embedding in a migration or trigger.

JSON to XML Converter

Convert JSON column values to XML for legacy systems, SOAP-based integrations, and databases that use XML natively (SQL Server's XML data type, Oracle XML DB). No code required for one-off conversions.

JSON to YAML Converter

Convert JSON schema definitions, database config files, and ORM mapping files to YAML format for use in tools like Flyway, Liquibase, and Alembic that prefer YAML-based migration definitions.

Hex Converter

Convert hexadecimal values when working with binary column data, UUID stored as BINARY(16), internal rowid representations, and raw byte sequences from BLOB columns. Decode MySQL's internal hex notation for bit-field and binary columns.

Base64 Encoder / Decoder

Decode Base64-encoded database passwords from application configs, Kubernetes secrets, and environment variables. Encode binary data for safe storage or transmission in text-only fields and JSON columns.

MD5 / Hash Generator

Generate and verify MD5/SHA hashes for data integrity checks, compare hash values after data migration to verify row-level fidelity, and test checksum-based deduplication logic before implementing in application code.

Password Generator

Generate strong random passwords for database user accounts, service account credentials, connection string secrets, and encryption keys across development, staging, and production environments.

URL Encoder / Decoder

Encode special characters in JDBC connection strings, database DSN URLs, and PostgreSQL connection URIs where the password or hostname contains characters that must be percent-encoded.

Crontab Calculator

Validate and explain the cron expressions that schedule database maintenance jobs — vacuums, backups, index rebuilds, statistics updates, and replication health checks. Confirm the schedule runs at the intended time before deploying.