Database

db_running_queries.sql

-- PostgreSQL
SELECT
  datname,
  usename,
  query,
  waiting,
  state,
  backend_start,
  xact_start,
  query_start,
  state_Change,
  client_addr || ':' || client_port AS client
FROM pg_stat_activity;

-- MySQL
SHOW PROCESSLIST;

db_version.sql

-- PostgreSQL and MySQL
SELECT version();

tables_row_count.sql

-- PostgreSQL
SELECT
  schemaname,
  relname,
  n_live_tup
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC;