Advanced

Tools

Debugging 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!

A simple way to inspect it? Use the SQLite VS Code extension!

Install SQLite VS Code Extension

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

If you don't see contents.sqlite, start your Nuxt app first:

Terminal

npx nuxi dev

Locate Your SQLite Database

Nuxt Content stores its database here:

.data/content/contents.sqlite

This file is automatically generated when you start your Nuxt app. No need to create it manually!

Open & Explore the Database

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

SQLite Explorer in VS Code

Fixing Common Issues

Content Not Showing?

Check if the database exists (.data/content/contents.sqlite).
Run a cleanup & restart Nuxt:
Terminal
```
npx nuxi cleanup && npx nuxi dev
```
Check if content is inside the database (run an SQL query).

Manually Reset the Database

If things seem really broken, try resetting it:

Delete the database file:
Terminal
```
rm -rf .data/content/contents.sqlite
```
Run cleanup to remove old caches:
Terminal
```
npx nuxi cleanup
```
Restart Nuxt to generate a fresh database:
Terminal
```
npx nuxi dev
```

Cleaning up will remove cached data. Don't worry—it regenerates automatically!

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.

SQL Storage

How Nuxt Content stores and retrieves content

Hooks

Modify your content using Nuxt build time hooks