ColumnCaster
Free database column name generator

Column names your future self will thank you for

Generate clean, conventional SQL column names in seconds. Pick a column type — primary key, foreign key, boolean, timestamp, text, numeric — choose your casing, and get a batch of consistent candidates. Everything runs 100% in your browser: no sign-up, no server, nothing stored.

Design your columns

100% in your browser

Used for key patterns like user_id.

Each type follows its own naming pattern. See the pattern catalog.

Casing style

snake_case is the SQL standard. Match your existing schema if it differs.

10

Generate a shortlist, then pick your favorites.

Generated columns

Press Generate names — click any column to copy it.

    Honest limits
    • These are naming suggestions, not a schema review. ColumnCaster can't check your database for existing names or reserved-word conflicts.
    • Avoid SQL reserved words (order, user, select) and check your database's identifier length limits before migrating.
    • Generated names never leave your browser. Nothing is uploaded, logged, or stored.

    Naming is the cheapest schema documentation

    A column named is_active needs no comment; a column named flag1 needs a wiki page nobody wrote. The conventions are simple — snake_case, descriptive words, is_ for booleans, _at for timestamps, <table>_id for keys — and the naming guide walks through all of them.

    Convention in one line: lowercase snake_case, singular nouns, no reserved words, type-revealing prefixes and suffixes. Everything else is team preference — documented once, applied always.

    How to use the generator

    1. Enter your table name so key columns come out as user_id rather than generic id.
    2. Pick a column type — or Mixed for a realistic spread across a new table.
    3. Choose casing. snake_case is the SQL default; match your ORM or existing schema if it differs.
    4. Generate, click to copy individual names, or copy all / download the shortlist for your migration or model file.

    Explore the column name patterns, browse naming by column type, or learn what to avoid in common mistakes.