SQLizer

SQLizer

Query every HTML table with SQL.

What is SQLizer?
SQLizer is a powerful Chrome extension that enables you to query HTML tables on any web page using the popular database language SQL. Simply select the text within a table, click the SQLizer button, and write your SQL query to retrieve the desired data. The extension utilizes a local SQLite database (Web SQL) for offline execution and supports various SQL features including joins, aggregate functions, nested queries, and more. SQLizer also offers features like auto completion, table renaming for joins, and the ability to export tables to files in SQL format.
Merlin
Stats
This extension was removed from Chrome Web Store on 2022-05-06
Users: 1,000+
Rating: 4.50 (6)
Version: 1.2.1 (Last updated: 2017-11-13)
Creation date: 2017-11-13
Risk impact: High risk impact
Risk likelihood: High risk likelihood
Manifest version: 2
Permissions:
  • tabs
  • http://*/*
  • https://*/*
Size: 36.92K
Stats date:

Other platforms

Not available on Firefox
Not available on Edge
Want to check extension ranking and stats more quickly for other Chrome extensions? Install Chrome-Stats extension to view Chrome-Stats data as you browse the Chrome Web Store.
Chrome-Stats extension
Merlin
Summary

The SQLizer allows to query every HTML table on a web site with the database language SQL.

  1. Select a piece of text in the table you want to query, e.g. with a double click on a word
  2. On the top right of your Google-Chrome window click the SQLizer button
  3. Write your SQL query and execute it

The whole script is executed offline using a local SQLite database (Web SQL).

SQLizer supports everything SQLite supports: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, IN, Aggregate Functions, Joins, Nested Queries, ...

New in Version 1.2.1:

  • Joins! Tables can be renamed, so that multiple tables from the same website, different websites, and different browser tabs can be joined.
  • Auto completion (Ctrl+Space) also for table names

New in Version 1.1:

See more
User reviews
it actually pulls some query hey!
by dancun chiriga dancun chiriga, 2016-05-08

Nice idea, bad execution. This extension can't handle <th> cells and also has a problem with periods in the column name. Since most of Wikipedia's tables have those, that makes it rather useless for me.
by FM-96, 2015-07-11

Endlich hemmungslos Datenanalyse betreiben ohne sich in R oder Excel einzuarbeiten. Da wünscht man sich doch das Tabellenlayout aus den 90ern zurück.
by Manuel Dossinger Manuel Dossinger, 2014-09-08
View all user reviews
Safety
Risk impact

SQLizer is risky to use as it requires a number of sensitive permissions that can potentially harm your browser and steal your data. Exercise caution when installing this extension. Review carefully before installing. We recommend that you only install SQLizer if you trust the publisher.

Risk likelihood

SQLizer may not be trust-worthy. Avoid installing if possible unless you really trust this publisher.

Upgrade to see risk analysis details
Similar extensions

Here are some Chrome extensions that are similar to SQLizer: