---

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

Task	Tool
View schema	database-schema
Run queries	database-query (SELECT only)
Eloquent	tinker

Key Tables

Table	Purpose
users	Authentication
property_managers	PM profiles (user_id, type, verified_at)
tenant_profiles	Tenant profiles (employment, docs)
properties	Listings (status, visibility)
applications	Tenant apps (status workflow)
leads	Conversion tracking
application_invite_tokens	Access control

Common Queries

SQL (database-query):

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

Eloquent (tinker):

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

Arguments

Usage	Behavior
/db-explore	Schema overview
/db-explore applications	Focus on table
/db-explore schema	Full schema
/db-explore "status = 'draft'"	Run condition

Safety

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