Google ChromeのパスワードDB（Login Data）をKeepass向けのCSVに変換するスクリプト。大したことはしてない。

chromepwd2csv.sh

# CREATE TABLE logins (origin_url VARCHAR NOT NULL,
#  action_url VARCHAR,
#  username_element VARCHAR,
#  username_value VARCHAR,
#  password_element VARCHAR,
#  password_value BLOB,
#  submit_element VARCHAR,
#  signon_realm VARCHAR NOT NULL,
#  preferred INTEGER NOT NULL,
#  date_created INTEGER NOT NULL,
#  blacklisted_by_user INTEGER NOT NULL,
#  scheme INTEGER NOT NULL,
#  password_type INTEGER,
#  possible_usernames BLOB,
#  times_used INTEGER,
#  form_data BLOB,
#  date_synced INTEGER,
#  display_name VARCHAR,
#  icon_url VARCHAR,
#  federation_url VARCHAR,
#  skip_zero_click INTEGER,
#  generation_upload_status INTEGER,
#  UNIQUE (origin_url, username_element, username_value, password_element, signon_realm)
# );
# CREATE INDEX logins_signon ON logins (signon_realm);

cat << EOF | sqlite3 "$*"
.mode csv
.output password.csv
select
	  signon_realm
	, username_value
	, password_value
	, signon_realm
	, datetime(substr(date_created,1,11),'unixepoch', 'localtime', '-369 year')
from logins;
EOF

split -d -l 115 password.csv "password_"