Type userAccountId to get user_account_id, live as you type. snake_case is the convention for Python, Ruby, Rust, SQL columns and many REST payloads. A lowercase letter or digit followed by an uppercase letter marks a split. All-caps runs such as APIKey do not split without a space. Conversion stays in this tab.
userAccountId
UserAccountId
user_account_id
user-account-id
USER_ACCOUNT_ID
Runs in this tab · nothing is uploaded · Verify in 10 seconds →
snake_case lowercases everything and joins words with underscores, detecting camelCase humps on the way in: userAccountId becomes user_account_id, and spaces and hyphens become underscores too. Type below and read the snake_case row, the CONSTANT_CASE row gives you the all-caps variant for free.
The conversion is driven by one regular expression boundary: a lowercase letter or digit followed by an uppercase letter ([a-z0-9] then [A-Z]) marks a word split, which is why userAccountId gains exactly two underscores. On the 244 unique keys in our sample corpus, 67 are multi-word, snake_case makes each of those boundaries cost one visible character, averaging 7.5 characters per key versus camelCase's 7.2.
All-caps acronym runs do not split (APIKey becomes apikey, not api_key), because no algorithm can find that boundary without a dictionary; write “API key” with a space to force it. If SQL is your destination and a converted name collides with a reserved word (order, user, group are classics), quote it or prefix it rather than trusting case conventions to save you.
snake_case is the convention for Python, Ruby, Rust, SQL column names and many REST payloads, use it when moving identifiers from JavaScript into schemas or API contracts.
This page is a focused view of theCase Converter, which has the full set of options.
The all-caps variant (CONSTANT_CASE row in this tool) conventionally marks constants and environment variables: MAX_RETRIES, DATABASE_URL.
SQL identifiers are case-insensitive by default in most databases (PostgreSQL folds unquoted names to lowercase), so word separation by capitals is lost, underscores survive.