I have something like 6k bookmarks. And sometime I need to search for very specific bookmark (with specific tittle and url and tags) or I need to export only some bookmark. It's really difficult to do with the browser. I use \[heidisql \](https://www.heidisql.com/)to connect to the sqlite database, that is \`places.sqlite\` in \`C:\\Users\\YourName\\AppData\\Roaming\\Mozilla\\Firefox\\Profiles\\YourFirefoxProfileId\\\`.



So here's the script to query all firefox bookmarks



\--tags and folders are all also named in the moz\_bookmarks table. All unique tags are of type=2 and parent=4. While all unique folders are of type=2 and parent<>4.

\--the column parent is self-reference to column id.

\--each unique bookmark is identified by unique fk. each unique bookmark can have few entries in the table (different ids). One is for the title, and the others are for tags. One entry for every tag. All entry for the same bookmark have same fk.

\--Every tags on a bookmark identified by reference in column parent, that itself is a reference to column id.



WITH	

all\_links AS (

SELECT [A.fk](http://A.fk),B.folder,A.title,datetime(A.dateAdded/1000000,'unixEpoch') AS dateAdded,datetime(A.lastModified/1000000,'unixEpoch') AS lastModified FROM 

(SELECT \* FROM moz\_bookmarks WHERE TYPE=1 AND moz\_bookmarks.title IS NOT NULL) A

INNER JOIN 

(SELECT id,title as folder FROM moz\_bookmarks WHERE TYPE = 2 AND parent<>4) B

ON A.parent=B.id),



folders AS (

SELECT id,title FROM moz\_bookmarks WHERE TYPE = 2 AND parent<>4),



with\_tags AS (

SELECT fk, GROUP\_CONCAT(grouped\_tags.title) AS tags FROM

(SELECT all\_tags.\*,moz\_bookmarks.title FROM 

(SELECT fk,parent FROM moz\_bookmarks WHERE title IS NULL AND TYPE=1) all\_tags

INNER JOIN

moz\_bookmarks

ON all\_tags.parent=moz\_bookmarks.id) grouped\_tags

GROUP BY fk)





SELECT moz\_links.\*,moz\_places.url,moz\_places.description,moz\_places.title,moz\_places.preview\_image\_url FROM 

(SELECT all\_links.fk,all\_links.folder,all\_links.title,all\_links.dateAdded,all\_links.lastModified,with\_tags.tags FROM

all\_links

LEFT JOIN 

with\_tags

ON with\_tags.fk=all\_links.fk) moz\_links

INNER JOIN 

moz\_places

ON moz\_links.fk=moz\_places.id

\--WHERE moz\_links.title LIKE '%how%' AND url LIKE '%reddit.com%' AND tags LIKE '%Linux%'

\--fruther query here \^

SQL Script to search or extract bookmark