WorkspaceDatabase ToolsClient-Side Sandbox

MongoDB ObjectId Decoder

Extract the embedded creation UTC timestamp, machine/process identifier hex, and counter from any 24-char MongoDB ObjectId.

Input Buffer

1 ln · 24 ch · 24 B

ENCODING: UTF-8AUTO-RUN: ENABLED

Output Buffer

OUT: 1 LN · 0 B⌘↵ RUN · ⌘⇧C COPY

How to Use MongoDB ObjectId Decoder

Paste one or more 24-character hex MongoDB ObjectIds.
View the exact UTC creation date, Unix epoch, 5-byte random value, and 3-byte counter.

Keyboard Shortcuts & Sandbox Guarantee

Run / Process tool outputCtrl + Enter

Copy primary output to clipboardCtrl + Shift + C

Open global command paletteCtrl + K

More in Database Tools

SQL Formatter

Prettify complex SQL queries (SELECT, JOIN, WHERE, GROUP BY, CTEs) with uppercase keyword normalization and clean clause indentation.

SQL Minifier

Compress multi-line SQL queries and strip `--` or `/* */` comments into a single-line statement.

SQL Query Validator

Perform static syntax validation and anti-pattern linting on SQL statements (unbalanced quotes/parens, `SELECT *`, missing `WHERE` on `DELETE`/`UPDATE`).

SQL to JSON Converter

Parse SQL `INSERT INTO` statements or ASCII table query outputs (`+---+---+`) into structured JSON arrays.

JSON to SQL Generator

Generate `CREATE TABLE` DDL schemas and batched `INSERT INTO` statements from a JSON array of objects.

MongoDB Query Formatter

Format and validate MongoDB filter queries and aggregation pipelines (`$match`, `$group`, `$lookup`, `$project`).