# ShortcutDB (Incomplete) | Shortcuts Library

> An NLP CSV Database for Shortcuts.

## What this shortcut does

Experimental, very limited api
Working features
Select
Basic where clauses
Insert
Features in development
More capable where clauses
Update
Delete
Join
Select Queries
Queries are natural language and can be presented in a number of ways.
(select|get|find|fetch|read) (my|the)? #Column (and|with|plus|along with|include|including|also) #Column (from|in|out of) the? (my|the)? #Table table?
“Select id and tags from Words”
“Find my Id and Tags in my words table”
“Get my Tags from the Words table”
“Read the tags in my Words table”
Where Clause
Basic where clauses are supported that perform “contains” checks for string matching. I’ll add <, >, =, and != later.
where #Column and #Column contain
“Select id and tags from Words where Tags contain (cosine)”
“Select id and tags from Words where Tags and word contain (Trig, cos)”
Insert Queries
Insert queries use parentheses to wrap the row to be inserted, the row ID is an auto generated uuid.
(add|insert|create) (row|value|entry|values)? (into|add to|insert into|to)? #Table
“Insert (someWord,someTag) into Words”
“Add row (someWord,someTag) to Words”
“Create entry (someWord,someTag) add to Words”
Delete Queries
(remove|delete|erase) (from|row|entry|rows|entries) (from|the|out of)? #Table
“Remove from Words where tags contain (physics)”
“Erase entries from Words where tags contain (physics)”

## Compatibility

iPhone, iPad

## Required apps



[View this page](https://shortcutlibrary.app/shortcuts/shortcutdb-incomplete)

[Download Shortcuts Library on the App Store](https://apps.apple.com/app/id6759494377)