SQL Identifier Slugifier
Paste headings or titles and get safe snake_case identifiers for tables and columns, with accents removed, duplicates numbered and reserved words avoided.
Use the tool
Why this tool exists
Importing a spreadsheet means turning headers like First Name, E-mail address or 2024 Revenue (EUR) into column names. Left as they are, they need quoting everywhere, begin with a digit, clash with keywords such as order or user, or repeat. Renaming each by hand is slow and inconsistent.
This tool normalises accents, replaces symbols such as ampersand and percent with words, and joins the parts in snake_case, camelCase or quoted kebab-case. It prefixes names that start with a digit, adds an underscore to common reserved words, caps the length to your database limit and numbers duplicates. The reserved word list is short, so check unusual names against your own database documentation.
How to use it
- Paste names, one per line.
- Choose snake_case, camelCase or kebab-case, a maximum length and the reserved word option.
- Copy the identifiers in the same order as your input.
Frequently asked questions
How are accents handled?
Letters are decomposed and the accent marks removed, so Café Étage becomes cafe_etage. The German sharp s becomes ss. Characters from non-Latin scripts are dropped.
What counts as a reserved word?
A built-in list of common SQL keywords such as select, order, group, user, table and key. A match gets a trailing underscore. Your database may reserve others.
What if two names turn out the same?
The first keeps its name, and later ones get _2, _3 and so on, trimmed so the result still fits the maximum length.
Why a maximum length of 63?
PostgreSQL truncates identifiers at 63 bytes and MySQL allows 64 characters. Names longer than your limit are cut here so they stay predictable.