Open FRM files in your browser

The definition of a MySQL or MariaDB table: its columns, their types and its keys. Open it right here with the table's rows from the files beside it, without a server. Nothing leaves your device.

Or drop it anywhere on this page

What you'll see

Your database opens as a folder in the file list, its tables and views with their rows counted, and each table you pick opens in the grid.

customers.frm

MariaDB 10.6 • InnoDB • 14 columns • 3 keys

  • Every table and view in a folder • Rows counted
  • Keys lead to the rows they point at
  • Search • Every table at once
  • Export • Save a table or the whole database

About FRM

Every MySQL up to 5.7 and every MariaDB writes an .frm for each table and view, in the database's folder of its data directory, beside the files that hold the rows: an .ibd for InnoDB, a .MYD and a .MYI for MyISAM. MySQL 8 dropped it for a data dictionary of its own, kept inside each .ibd. Its format comes from UNIREG, the program MySQL grew out of.

Inside, an .frm is binary: a head naming the engine and the character set, the keys and their parts, the screen UNIREG drew, and each column's type, length, place in a row and default. A view's .frm is text instead, its query in a file that starts TYPE=VIEW.

Filepeek reads an .frm itself in your browser and opens the table, or the whole folder, in a grid with its columns typed as MySQL writes them. With the .ibd, or the .MYD and .MYI, beside it the rows show too, and Export saves the table as CSV, Excel or a SQL dump. An .frm on its own opens with its columns and no rows.

MySQL table definition

Format

MIME type
application/octet-stream
Made by
MySQL and MariaDB
Released
1995

Inside the file

Columns
Type, length and default
Keys
With their parts
Engines
InnoDB, MyISAM and more
Views
Text, with their query

Opens in every browser

Filepeek opens FRM files in Chrome, Edge, Firefox and Safari. On their own, browsers only download them, and only a MySQL or MariaDB server reads them.

  • YouChromeOpens through Filepeek
  • YouEdgeOpens through Filepeek
  • YouFirefoxOpens through Filepeek
  • YouSafariOpens through Filepeek

Apps that open FRM

  • WindowsMySQL or MariaDB, with the folder in its data directory
  • MacMySQL or MariaDB from Homebrew, with the folder in its data directory
  • iPhone and iPadNo app opens it
  • AndroidNo app opens it

Questions

How do I open an FRM file?

Drop it on this page with the .ibd, or the .MYD and .MYI, of its name, or drop the whole database folder. Its table opens as a grid, its columns typed as MySQL writes them.

Can I see a table's structure without MySQL?

Yes. An .frm alone opens as its table's columns and keys, with no rows, and Export's SQL dump writes its CREATE TABLE.

Where are a table's rows?

In the .ibd of the same name for InnoDB, or in the .MYD with its .MYI for MyISAM. Aria, which MariaDB uses for its own tables, keeps them in .MAD and .MAI files, which Filepeek doesn't read.

Why does a view's .frm open as text?

MySQL writes a view's .frm as text, with its query, its algorithm and who made it. A view keeps no rows of its own, so Filepeek shows that text.

Is my .frm a Visual Basic form?

Visual Basic 6 saved its forms as .frm too, as text. Filepeek tells them apart by their first bytes, so a Visual Basic form opens as its text.

More data formats

All supported file types

Tell us what happened

Where the file came from helps us most

With itNever the file or its name
Thank you

Opens in a new tab

Keys

Everywhere

EXIF

Verify

License

Signature