Tasker SQLite Plugin

72 reviews
Content rating
Screenshot image
Screenshot image

About this app

The easier way to query databases with Tasker, now with the ability to create your own databases! No need to hunt for a SQLite binary that is compatible with your phone. Simply add the Tasker SQLite Plugin step to a Tasker task, input the path to the database and your sql statement, and execute.

========== Return Variables ==========
For INSERT statements with columns specified i.e. INSERT INTO tTableName(colX, colY) VALUES (valX, valY):
%dbrowid = the row id of the newly inserted row

For SELECT statments:
%dbreturn = the output of the sql statement in the same way as the sqlite binary (columns separated by pipes and rows separated by new lines) so it can be dropped in without any other changes to existing SQLite tasks.
%dbreturncount = the number of rows returned
%dbrows() = an array of rows so you don't have to split %dbreturn by the new line character
%db[column_name_lower_case]() = an array of values for each column (replace [column_name_lower_case] with the actual name of the column)

This app is currently in beta. Please report any issues via email.

Root is required to access other app's databases.
Updated on
Apr 1, 2016

Data safety

Developers can show information here about how their app collects and uses your data. Learn more about data safety
No information available

Ratings and reviews

70 reviews
Ilia Bakhmoutski
June 23, 2020
Extrememly buggy. Only basics work. The app has been in beta for several years now. I can only assume that it is no longer being developed. Too bad as it looks promissing.
2 people found this review helpful
Did you find this helpful?
A Google user
August 5, 2019
i cant do select with a where clause, it did not work, also how do i insert a text tyoe without ending up with "" around it Might be abounded , dev email is not working
2 people found this review helpful
Did you find this helpful?
Jason Ooi
December 20, 2020
Deprecated. Tasker has a built in SQL Query action.
4 people found this review helpful
Did you find this helpful?

What's new

-Fixed crash when creating a database
-Better %dberr messages if database creation fails