Views

List all database views:

wowsql views list

Create a database view:

wowsql views create user_summary "SELECT id, name, email FROM users"

Describe view structure:

wowsql views describe user_summary

Stored Procedures

List all stored procedures:

wowsql procedures list

Create a stored procedure:

wowsql procedures create get_user "SELECT * FROM users WHERE id = ?"

Execute a stored procedure:

wowsql procedures execute get_user --params "123"

Indexes

List indexes for a table:

wowsql indexes list users

Create an index:

wowsql indexes create idx_email users email --unique

Analyze index usage:

wowsql indexes analyze users

Triggers

List triggers for a table:

wowsql triggers list users

Create a trigger:

wowsql triggers create update_timestamp users BEFORE UPDATE "SET NEW.updated_at = NOW()"

Delete a trigger:

wowsql triggers delete update_timestamp