RSQLite
R RSQLite package for SQLite databases. Use for embedded SQLite database connections.
— No reviews yet
0 installs
16 views
0.0% view→install
Install
$ agentstack add skill-leolin990405-r-analytics-skill-rsqlite ✓ scanned · ✓ verified — works with Claude Code, Cursor, and more.
Security review
✓ PassedNo issues found. Passed automated security review. · v0.1.0 How review works →
- ✓ Prompt-injection patterns
- ✓ Secret / credential exfiltration
- ✓ Dangerous shell & filesystem operations
- ✓ Untrusted network calls
- ✓ Known-malicious package signatures
What it can access
- ✓ Network access No
- ✓ Filesystem access No
- ✓ Shell / process execution No
- ✓ Environment & secrets No
- ✓ Dynamic code execution No
From automated source analysis of v0.1.0. “Used” means the capability is present in the source — more access means more to trust, not that it’s unsafe.
Are you the author of RSQLite? Claim this listing to set pricing, connect Stripe payouts, and keep 70% of every sale.
Sign up to claimAbout
RSQLite Package
SQLite database interface.
Connect
library(DBI)
library(RSQLite)
# File database
con 20")
# Remove table
dbRemoveTable(con, "mtcars")Parameterized Queries
# Safe from SQL injection
dbGetQuery(con,
"SELECT * FROM users WHERE id = ?",
params = list(user_id)
)
# Named parameters
dbGetQuery(con,
"SELECT * FROM users WHERE name = :name AND age > :age",
params = list(name = "John", age = 25)
)Transactions
dbBegin(con)
tryCatch({
dbExecute(con, "INSERT INTO ...")
dbExecute(con, "UPDATE ...")
dbCommit(con)
}, error = function(e) {
dbRollback(con)
stop(e)
})Disconnect
dbDisconnect(con)Source & license
This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.
- Author: LeoLin990405
- Source: LeoLin990405/r-analytics-skill
- License: MIT
Install and usage instructions live in the source repository linked above.
Reviews
No reviews yet — be the first.
Write a review
Versions
- v0.1.0 Imported from the upstream source.