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.
- 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
.frm
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.