How long does the integration take?

Change one base URL in an OpenAI-compatible client, or install the Python or TypeScript SDK; the quickstart routes a first request in a few minutes.

Will this lock us into another vendor?

No. The router is Apache-2.0 open source, your provider keys stay yours, and the API is OpenAI-compatible, so leaving is a change of base URL.

What happens when a provider fails?

The router falls back to the next model your policy allows and records the fallback in the trace, so an outage costs a retry, not an incident.

laravel - Prompt - OpenSmartRoute

Name: laravel
Author: waw3

Prompt file imported from waw3/rer-form (.claude/commands/getdb/laravel.md). Fill in {{OUTPUT}} before use. Copyright stays with the author.

Laravel Database Documentation

Generate comprehensive database documentation using Laravel's schema introspection with Eloquent relationships and Mermaid diagrams.

Usage

Generate database documentation with Laravel's artisan command:

# Basic usage (saves to api/docs/database.md)
/getdb:laravel

# Custom output location
/getdb:laravel --output docs/db-structure.md

# Save to Claude's reference location
/getdb:laravel --output ../claude/database.md

Examples

# Example 1: Default documentation generation
/getdb:laravel

# Example 2: Custom documentation path
/getdb:laravel --output docs/database-v2.md

# Example 3: Generate for project documentation
/getdb:laravel --output ../docs/technical/database.md

# Example 4: Update Claude's database reference
/getdb:laravel --output ../.claude/database.md

Command Execution

cd api && php artisan claude:getdb --output="{{OUTPUT}}"

Parameters

Optional Parameters

--output [file_path]: Output file path relative to api/ directory (default: docs/database.md)

Environment Variables

Laravel uses database configuration from api/.env
DB_CONNECTION: Database driver (mysql)
DB_DATABASE: Database name
DB_USERNAME: Database user
DB_PASSWORD: Database password

Features

Eloquent Awareness: Includes model relationships and scopes
Mermaid Diagrams: Visual entity relationship diagrams
Comprehensive Metadata: Column types, defaults, nullable flags
Index Documentation: All indexes with type and uniqueness
Foreign Key Mapping: Complete FK relationships with cascade rules
Model Integration: Can include model-specific documentation
Migration History: References migration files
Automatic Formatting: Clean markdown with TOC

Requirements/Dependencies

System Requirements

PHP 8.1 or higher
Laravel 10 or higher
Composer dependencies installed
Database connection configured

Installation Verification

# Check Laravel installation
cd api && php artisan --version

# Verify command exists
php artisan list | grep claude:getdb

# Test database connection
php artisan tinker --execute="DB::connection()->getPdo()"

Output

Generated Documentation Structure

Header Section
- Generation timestamp
- Total table count
- Database statistics
Table of Contents
- Alphabetical table listing
- Quick navigation links
Entity Relationship Diagram
- Mermaid ER diagram
- Visual foreign key relationships
Per-Table Documentation
- Column specifications (name, type, nullable, default, auto-increment)
- Index definitions (name, columns, type, unique, primary)
- Foreign key constraints (name, columns, references, cascade rules)

Sample Output

# Database Structure

Generated on: 2024-01-15 10:30:00
Total tables: 165

## Table of Contents
- [entities](#entities)
- [reports](#reports)
...

## Entity Relationships

\```mermaid
erDiagram
    reports ||--o{ entities : has
    entities ||--o{ payments : has
\```

## reports

### Columns
| Column | Type | Nullable | Default | Auto Increment | Comment |
|--------|------|----------|---------|----------------|---------|
| id | char(26) | NO | NULL | NO | ULID primary key |
| firm_id | char(26) | NO | NULL | NO | Foreign key to firms |
...

Advanced Usage

Integration with Documentation

# Generate and commit documentation
/getdb:laravel --output docs/database.md
git add api/docs/database.md
git commit -m "Update database documentation"

Comparison Workflow

# Before schema changes
/getdb:laravel --output docs/db-before.md

# Make migrations
php artisan migrate

# After schema changes
/getdb:laravel --output docs/db-after.md

# Compare
diff api/docs/db-before.md api/docs/db-after.md

Notes

Generation time: 10-30 seconds depending on table count
Includes Laravel-specific metadata not available via raw SQL
Respects Laravel's database abstraction layer
Can include soft delete timestamps
Mermaid diagrams require markdown viewer support
File is saved relative to api/ directory

Troubleshooting

Common Issues

Issue 1: Command not found

Solution: Ensure command is registered in Laravel
Check: php artisan list | grep claude
Fix: Run composer dump-autoload

Issue 2: Database connection failed

Solution: Check .env configuration
Verify: php artisan config:cache
Test: php artisan tinker then DB::connection()->getPdo()

Issue 3: Permission denied on output

Solution: Check write permissions
Fix: mkdir -p api/docs && chmod 755 api/docs

Issue 4: Memory exhausted

Solution: Increase PHP memory limit
Fix: Add to .env: PHP_MEMORY_LIMIT=512M

Related Commands

/getdb:mysql: Direct MySQL documentation (faster, simpler)
/migrate: Run database migrations
/check: Validate database structure

Install laravel and it becomes one more candidate the router can pick - when it fits.

A listing is a routing target with a manifest: what it does, which domains it covers, what it costs and who publishes it. Once installed it sits beside your own models and tools, is scored like any other candidate for each request, and shows up in the trace when it wins. Ratings come from workspaces that installed it, one per account.

# Laravel Database Documentation Generate comprehensive database documentation using Laravel's schema introspection with Eloquent relationships and Mermaid diagrams. ## Usage Generate database documentation with Laravel's artisan command: ```bash # Basic usage (saves to api/docs/database.md) /getdb:laravel # Custom output location /getdb:laravel --output docs/db-structure.md # Save to Claude's reference location /getdb:laravel --output ../claude/database.md ``` ## Examples ```bash # Example 1: Default documentation generation /getdb:laravel # Example 2: Custom documentation path /getdb:laravel --output docs/database-v2.md # Example 3: Generate for project documentation /getdb:laravel --output ../docs/technical/database.md # Example 4: Update Claude's database reference /getdb:laravel --output ../.claude/database.md ``` ## Command Execution ```bash cd api && php artisan claude:getdb --output="{{OUTPUT}}" ``` ## Parameters ### Optional Parameters - `--output [file_path]`: Output file path relative to api/ directory (default: docs/database.md) ### Environment Variables - Laravel uses database configuration from `api/.env` - `DB_CONNECTION`: Database driver (mysql) - `DB_DATABASE`: Database name - `DB_USERNAME`: Database user - `DB_PASSWORD`: Database password ## Features - **Eloquent Awareness**: Includes model relationships and scopes - **Mermaid Diagrams**: Visual entity relationship diagrams - **Comprehensive Metadata**: Column types, defaults, nullable flags - **Index Documentation**: All indexes with type and uniqueness - **Foreign Key Mapping**: Complete FK relationships with cascade rules - **Model Integration**: Can include model-specific documentation - **Migration History**: References migration files - **Automatic Formatting**: Clean markdown with TOC ## Requirements/Dependencies ### System Requirements - PHP 8.1 or higher - Laravel 10 or higher - Composer dependencies installed - Database connection configured ### Installation Verification ```bash # Check Laravel installation cd api && php artisan --version # Verify command exists php artisan list | grep claude:getdb # Test database connection php artisan tinker --execute="DB::connection()->getPdo()" ``` ## Output ### Generated Documentation Structure 1. **Header Section** - Generation timestamp - Total table count - Database statistics 2. **Table of Contents** - Alphabetical table listing - Quick navigation links 3. **Entity Relationship Diagram** - Mermaid ER diagram - Visual foreign key relationships 4. **Per-Table Documentation** - Column specifications (name, type, nullable, default, auto-increment) - Index definitions (name, columns, type, unique, primary) - Foreign key constraints (name, columns, references, cascade rules) ### Sample Output ```markdown # Database Structure Generated on: 2024-01-15 10:30:00 Total tables: 165 ## Table of Contents - [entities](#entities) - [reports](#reports) ... ## Entity Relationships \```mermaid erDiagram reports ||--o{ entities : has entities ||--o{ payments : has \``` ## reports ### Columns | Column | Type | Nullable | Default | Auto Increment | Comment | |--------|------|----------|---------|----------------|---------| | id | char(26) | NO | NULL | NO | ULID primary key | | firm_id | char(26) | NO | NULL | NO | Foreign key to firms | ... ``` ## Advanced Usage ### Integration with Documentation ```bash # Generate and commit documentation /getdb:laravel --output docs/database.md git add api/docs/database.md git commit -m "Update database documentation" ``` ### Comparison Workflow ```bash # Before schema changes /getdb:laravel --output docs/db-before.md # Make migrations php artisan migrate # After schema changes /getdb:laravel --output docs/db-after.md # Compare diff api/docs/db-before.md api/docs/db-after.md ``` ## Notes - Generation time: 10-30 seconds depending on table count - Includes Laravel-specific metadata not available via raw SQL - Respects Laravel's database abstraction layer - Can include soft delete timestamps - Mermaid diagrams require markdown viewer support - File is saved relative to api/ directory ## Troubleshooting ### Common Issues **Issue 1: Command not found** - Solution: Ensure command is registered in Laravel - Check: `php artisan list | grep claude` - Fix: Run `composer dump-autoload` **Issue 2: Database connection failed** - Solution: Check .env configuration - Verify: `php artisan config:cache` - Test: `php artisan tinker` then `DB::connection()->getPdo()` **Issue 3: Permission denied on output** - Solution: Check write permissions - Fix: `mkdir -p api/docs && chmod 755 api/docs` **Issue 4: Memory exhausted** - Solution: Increase PHP memory limit - Fix: Add to .env: `PHP_MEMORY_LIMIT=512M` ## Related Commands - `/getdb:mysql`: Direct MySQL documentation (faster, simpler) - `/migrate`: Run database migrations - `/check`: Validate database structure

{ "prompt": "# Laravel Database Documentation\n\nGenerate comprehensive database documentation using Laravel's schema introspection with Eloquent relationships and Mermaid diagrams.\n\n## Usage\n\nGenerate database documentation with Laravel's artisan command:\n\n```bash\n# Basic usage (saves to api/docs/database.md)\n/getdb:laravel\n\n# Custom output location\n/getdb:laravel --output docs/db-structure.md\n\n# Save to Claude's reference location\n/getdb:laravel --output ../claude/database.md\n```\n\n## Examples\n\n```bash\n# Example 1: Default documentation generation\n/getdb:laravel\n\n# Example 2: Custom documentation path\n/getdb:laravel --output docs/database-v2.md\n\n# Example 3: Generate for project documentation\n/getdb:laravel --output ../docs/technical/database.md\n\n# Example 4: Update Claude's database reference\n/getdb:laravel --output ../.claude/database.md\n```\n\n## Command Execution\n\n```bash\ncd api && php artisan claude:getdb --output=\"{{OUTPUT}}\"\n```\n\n## Parameters\n\n### Optional Parameters\n- `--output [file_path]`: Output file path relative to api/ directory (default: docs/database.md)\n\n### Environment Variables\n- Laravel uses database configuration from `api/.env`\n- `DB_CONNECTION`: Database driver (mysql)\n- `DB_DATABASE`: Database name\n- `DB_USERNAME`: Database user\n- `DB_PASSWORD`: Database password\n\n## Features\n\n- **Eloquent Awareness**: Includes model relationships and scopes\n- **Mermaid Diagrams**: Visual entity relationship diagrams\n- **Comprehensive Metadata**: Column types, defaults, nullable flags\n- **Index Documentation**: All indexes with type and uniqueness\n- **Foreign Key Mapping**: Complete FK relationships with cascade rules\n- **Model Integration**: Can include model-specific documentation\n- **Migration History**: References migration files\n- **Automatic Formatting**: Clean markdown with TOC\n\n## Requirements/Dependencies\n\n### System Requirements\n- PHP 8.1 or higher\n- Laravel 10 or higher\n- Composer dependencies installed\n- Database connection configured\n\n### Installation Verification\n\n```bash\n# Check Laravel installation\ncd api && php artisan --version\n\n# Verify command exists\nphp artisan list | grep claude:getdb\n\n# Test database connection\nphp artisan tinker --execute=\"DB::connection()->getPdo()\"\n```\n\n## Output\n\n### Generated Documentation Structure\n\n1. **Header Section**\n - Generation timestamp\n - Total table count\n - Database statistics\n\n2. **Table of Contents**\n - Alphabetical table listing\n - Quick navigation links\n\n3. **Entity Relationship Diagram**\n - Mermaid ER diagram\n - Visual foreign key relationships\n\n4. **Per-Table Documentation**\n - Column specifications (name, type, nullable, default, auto-increment)\n - Index definitions (name, columns, type, unique, primary)\n - Foreign key constraints (name, columns, references, cascade rules)\n\n### Sample Output\n\n```markdown\n# Database Structure\n\nGenerated on: 2024-01-15 10:30:00\nTotal tables: 165\n\n## Table of Contents\n- [entities](#entities)\n- [reports](#reports)\n...\n\n## Entity Relationships\n\n\\```mermaid\nerDiagram\n reports ||--o{ entities : has\n entities ||--o{ payments : has\n\\```\n\n## reports\n\n### Columns\n| Column | Type | Nullable | Default | Auto Increment | Comment |\n|--------|------|----------|---------|----------------|---------|\n| id | char(26) | NO | NULL | NO | ULID primary key |\n| firm_id | char(26) | NO | NULL | NO | Foreign key to firms |\n...\n```\n\n## Advanced Usage\n\n### Integration with Documentation\n```bash\n# Generate and commit documentation\n/getdb:laravel --output docs/database.md\ngit add api/docs/database.md\ngit commit -m \"Update database documentation\"\n```\n\n### Comparison Workflow\n```bash\n# Before schema changes\n/getdb:laravel --output docs/db-before.md\n\n# Make migrations\nphp artisan migrate\n\n# After schema changes\n/getdb:laravel --output docs/db-after.md\n\n# Compare\ndiff api/docs/db-before.md api/docs/db-after.md\n```\n\n## Notes\n\n- Generation time: 10-30 seconds depending on table count\n- Includes Laravel-specific metadata not available via raw SQL\n- Respects Laravel's database abstraction layer\n- Can include soft delete timestamps\n- Mermaid diagrams require markdown viewer support\n- File is saved relative to api/ directory\n\n## Troubleshooting\n\n### Common Issues\n\n**Issue 1: Command not found**\n- Solution: Ensure command is registered in Laravel\n- Check: `php artisan list | grep claude`\n- Fix: Run `composer dump-autoload`\n\n**Issue 2: Database connection failed**\n- Solution: Check .env configuration\n- Verify: `php artisan config:cache`\n- Test: `php artisan tinker` then `DB::connection()->getPdo()`\n\n**Issue 3: Permission denied on output**\n- Solution: Check write permissions\n- Fix: `mkdir -p api/docs && chmod 755 api/docs`\n\n**Issue 4: Memory exhausted**\n- Solution: Increase PHP memory limit\n- Fix: Add to .env: `PHP_MEMORY_LIMIT=512M`\n\n## Related Commands\n\n- `/getdb:mysql`: Direct MySQL documentation (faster, simpler)\n- `/migrate`: Run database migrations\n- `/check`: Validate database structure", "variables": [ "OUTPUT" ], "notes": "Generate database documentation using Laravel's schema introspection Tools: all. Arguments: [--output file].", "metadata": { "source": { "provider": "github-claude-commands", "repository": "https://github.com/waw3/rer-form", "path": ".claude/commands/getdb/laravel.md", "ref": "4ba72c361c9ef7e3d6f0b0142958bab4b258ffd5", "url": "https://github.com/waw3/rer-form/blob/4ba72c361c9ef7e3d6f0b0142958bab4b258ffd5/.claude/commands/getdb/laravel.md", "key": "waw3/rer-form/.claude/commands/getdb/laravel.md" } } }

laravel

About