Ferrum Marketplace

SQL for MySQL and Postgres

Vyloxi ✔ · ⬇ 0 installs · Snippets

Tables, indexes, upserts, JSON, window functions, CTEs, users and admin queries for MySQL and PostgreSQL.

vyloxi.sql-mysql-postgres-snippets Download .fext

In Ferrum open Extensions in the sidebar, search for SQL for MySQL and Postgres and press Install. Or use Extensions: Install from File with the downloaded file.

Overview Contributions Versions (1) Reviews (0)

SQL for MySQL and Postgres

Tables, indexes, upserts, JSON, window functions, CTEs, users and admin queries for MySQL and PostgreSQL.

Type a prefix and press Tab. 44 snippets.

Language Prefix What it inserts
SQL pgtable A Postgres table
SQL mytable A MySQL table
SQL pgupsert INSERT ... ON CONFLICT
SQL myupsert INSERT ... ON DUPLICATE KEY
SQL fk A foreign key
SQL idx An index
SQL pgidx A partial index
SQL pgjson Query a JSONB column
SQL myjson Query a JSON column
SQL cte A common table expression
SQL rcte A recursive CTE
SQL winrow ROW_NUMBER per group
SQL topn The newest row per group
SQL page LIMIT and OFFSET
SQL dups Find duplicates
SQL pgexplain EXPLAIN ANALYZE
SQL myexplain EXPLAIN
SQL pguser A role with privileges
SQL myuser A user with privileges
SQL pgsize Largest tables
SQL mysize Largest tables
SQL pgtrig Keep updated_at fresh
SQL Dialects pgtable A Postgres table
SQL Dialects mytable A MySQL table
SQL Dialects pgupsert INSERT ... ON CONFLICT
SQL Dialects myupsert INSERT ... ON DUPLICATE KEY
SQL Dialects fk A foreign key
SQL Dialects idx An index
SQL Dialects pgidx A partial index
SQL Dialects pgjson Query a JSONB column
SQL Dialects myjson Query a JSON column
SQL Dialects cte A common table expression
SQL Dialects rcte A recursive CTE
SQL Dialects winrow ROW_NUMBER per group
SQL Dialects topn The newest row per group
SQL Dialects page LIMIT and OFFSET
SQL Dialects dups Find duplicates
SQL Dialects pgexplain EXPLAIN ANALYZE
SQL Dialects myexplain EXPLAIN
SQL Dialects pguser A role with privileges
SQL Dialects myuser A user with privileges
SQL Dialects pgsize Largest tables
SQL Dialects mysize Largest tables
SQL Dialects pgtrig Keep updated_at fresh

This extension runs no code and asks for no permissions.