• Installation
• Usage
• MIME types defined
  • If you need to update the editor value with dispatch here is an example:
    • Optional (Already included in the view)
• Links
• License

#Installation

You can install the package via composer:

composer require mrpowerup/filament-sql-field

#Usage

use MrPowerUp\FilamentSqlField\FilamentSqlField;

public static function form(Form $form): Form
    {
        return $form
            ->schema([
                    FilamentSqlField::make('sql')
                        ->mime('text/x-mysql') // Define MIME Type
                        ->fullscreen() // Allow Fullscreen mode
                        // ->hintIcon('heroicon-m-question-mark-circle', tooltip: "F11: Fullscreen | Ctrl + Space: Autocomplete | ESC: Exit Fullscreen mode")
                        ->connection('mysql') // Set connection
                        ->autoGetTables() // Automatically get tables from database
                        ->editorHeight(300) // Set height of editor
                        ->dark() // Switch to Dark theme (Dracula Theme)
                        ->default("SELECT * FROM users WHERE 1;") // Default SQL
                        ->tables([
                            'table1' => [
                                'column1',
                                'column2',
                                'column3'
                            ],
                            'table2' => [
                                'column1',
                                'column2',
                                'column3'
                            ]
                        ]) // Manually set tables
                        ->columnSpanFull(),
            ]);
    }

#MIME types defined

• text/x-sql
• text/x-mysql
• text/x-mariadb
• text/x-cassandra
• text/x-plsql
• text/x-mssql
• text/x-hive
• text/x-pgsql
• text/x-gql
• text/x-gpsql
• text/x-esper
• text/x-sqlite
• text/x-sparksql
• text/x-trino

#If you need to update the editor value with dispatch here is an example:

$this->dispatch('updatePlugin', 'SELECT * FROM table_name WHERE 1;');

#Optional (Already included in the view)

@script
    <script>
        $wire.on('updatePlugin', (event) => {
            window.editor.setValue(event[0]);
        });
    </script>
@endscript

#Links

• Source Code
• Packagist

#License

The MIT License (MIT). Please see License File for more information.