Ask the SQLite shell for index advice.
Section: Planner tools
Use the .expert shell helper
bash
bash
sqlite3 app.db ".expert"Explanation
The SQLite CLI includes tools that can help surface candidate indexes for sample queries.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Planner tools