---

name: db-explore description: Safe database exploration using Laravel Boost tools. Use for querying data, understanding schema, checking records, and debugging data issues. Auto-triggers on "query database", "check data", "find records", "database query", "show me the data".

Database Exploration

Tools

Key Tables

Common Queries

SQL (database-query):

CopySELECT status, COUNT(*) FROM applications GROUP BY status;
SELECT * FROM users WHERE email = 'test@example.com';

Eloquent (tinker):

CopyUser::with(['propertyManager', 'tenantProfile'])->find(1);
Application::where('status', 'submitted')->count();
Property::withCount('applications')->orderByDesc('applications_count')->take(10)->get();

Arguments

Safety

• database-query = read-only (SELECT, SHOW, EXPLAIN, DESCRIBE)
• Always use LIMIT
• Use tinker with approval for writes