The octopus package is a database management tool built entirely in R. You can preview tables, upload files, send queries, and more.
All database credentials are handled by the R user. Simply pass a
supported database connection object created with
DBI::dbConnect() to the function
octopus::view_database() and octopus will start a
shiny application allowing you to interact with the database.
Try it out here! shinyapps.io
The octopus package currently supports the following databases:
::list_drivers() octopus#>  "PqConnection" "Snowflake" "Vertica Database" #>  "duckdb_connection" "MySQLConnection" "SQLiteConnection" #>  "Microsoft SQL Server"
Install the stable version from CRAN.
Install the development version from github.
Here is an example of connecting to a database and running the main function of octopus.
# Create a Database Connection <- duckdb::duckdb() drv <- DBI::dbConnect(drv) con # Write some data ::dbWriteTable(con, "mtcars", mtcars) DBI # View the Database ::view_database(con)octopus