[main]
smart_completion = True
multi_line = False
destructive_warning = True
history_file = ~/.mycli-history
log_file = ~/.mycli.log
log_level = INFO
timing = True
table_format = mysql_unicode
syntax_style = monokai
key_bindings = emacs
wider_completion_menu = False
enable_pager = True
auto_vertical_output = True
use_keyring = True
null_string = <null>
numeric_alignment = right
binary_display = hex
keyword_casing = auto
min_completion_trigger = 1

[alias_dsn]
local = mysql://root@localhost:3306/mydb
prod = mysql://admin@prod-server:3306/mydb
desarrollo = mysql://dev@dev-server:3306/mydb

[colors]
completion-menu.completion.current = bg:#ffffff #000000
output.header = #00ff5f bold
bottom-toolbar = bg:#222222 #aaaaaa

[favorite_queries]
tablas = SELECT TABLE_NAME, TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA='$1'
conexiones = SELECT * FROM information_schema.PROCESSLIST
tamanos = SELECT table_name, round(((data_length + index_length) / 1024 / 1024), 2) AS 'Size (MB)' FROM information_schema.TABLES WHERE table_schema = '$1' ORDER BY (data_length + index_length) DESC