Tools

Nuxt Content uses an SQLite database (contents.sqlite) to store and query content efficiently. If you're running into missing content, slow queries, or database issues, debugging your SQLite database can help!

Install SQLite VS Code Extension

1. Open Visual Studio Code.
2. Go to the Extensions panel (Ctrl+Shift+X / Cmd+Shift+X on Mac).
3. Search for "SQLite" (by alexcvzz) and install it.
4. Open your Nuxt Content database (.data/content/contents.sqlite).

npx nuxi dev

Locate Your SQLite Database

Nuxt Content stores its database here:

.data/content/contents.sqlite

Open & Explore the Database

1. Right-click on contents.sqlite in VS Code.
2. Select "Open Database".
3. Expand the Database Explorer panel to view tables & data.

Fixing Common Issues

Content Not Showing?

1. Check if the database exists (.data/content/contents.sqlite).
2. Run a cleanup & restart Nuxt:
   Terminal

   npx nuxi cleanup && npx nuxi dev
   

3. Check if content is inside the database (run an SQL query).

Manually Reset the Database

If things seem really broken, try resetting it:

1. Delete the database file:
   Terminal

   rm -rf .data/content/contents.sqlite
   

2. Run cleanup to remove old caches:
   Terminal

   npx nuxi cleanup
   

3. Restart Nuxt to generate a fresh database:
   Terminal

   npx nuxi dev
   

More Debugging Tools

If VS Code isn’t enough, check out:

• 🖥️ DB Browser for SQLite – A visual tool for inspecting & modifying the database.
• 🛠️ SQLite Command Line – Use sqlite3 contents.sqlite to run SQL queries from your terminal.