query-rds-data-0.5.1 is not a library.
Query AWS RDS Data from the command line
Goal
Installing
Prebuilt binaries for some major platforms are available under
Github releases.
If you have the Rust tool chain installed,
cargo install query-rds-data
will work.
Building
This project is written in Rust. The way to install Rust is from
Rustup.rs. Once Rust is installed on your machine,
running cargo build
in the root of this checkout should just work
and produces a debug binary in target/debug/query-rds-data
.
Built-in help
$ cargo build Finished dev [unoptimized + debuginfo] target(s) in 0.22s
$ target/debug/query-rds-data --help
query-rds-data 0.5.1
Query an Amazon RDS database
USAGE:
query-rds-data [FLAGS] [OPTIONS] <query> --aws-profile <profile>
FLAGS:
-h, --help Prints help information
-q, --quiet Silence all output
-V, --version Prints version information
-v, --verbose Verbose mode (-v, -vv, -vvv, etc)
OPTIONS:
-c, --db-cluster-identifier <db-id> RDS database identifier.
-p, --aws-profile <profile>
AWS source profile to use. This name references an entry
in ~/.aws/credentials [env: AWS_PROFILE=]
-r, --aws-region <region>
AWS region to target. [env: AWS_DEFAULT_REGION=]
[default: us-east-1]
-t, --timestamp <ts>
Timestamp (sec, ms, ns, none)
-u, --db-user-identifier <user-id>
RDS user identifier (really the AWS secret identifier).
ARGS:
<query> SQL query.
Error messages
I hope that the error messages from query-rds-data
are helpful for figuring out what went wrong and how to address the issue.
$ query-rds-data "select * from db1.names"
Error: No DBs found
$ query-rds-data "select * from db1.names" --db-cluster-identifier nope
Error: No DB matched "nope", available ids are []
$ query-rds-data "select * from db1.names" --db-cluster-identifier nope
Error: No DB matched "nope", available ids are ["demo"]
$ query-rds-data "select * from db1.names"
Error: No DB user secrets found
$ query-rds-data "select * from db1.names" --db-user-identifier fake
Error: No DB user matched "fake", available users are []
$ query-rds-data "create database db1"
""
$ query-rds-data "create table db1.names (id int, name varchar(64))"
""
$ query-rds-data "insert into db1.names values (1,'Bruce')"
""
$ query-rds-data "select * from db1.names"
id,name
1,Bruce
$ query-rds-data "select * from information_schema.tables where table_schema='db1'"
TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,ENGINE,VERSION,ROW_FORMAT,TABLE_ROWS,AVG_ROW_LENGTH,DATA_LENGTH,MAX_DATA_LENGTH,INDEX_LENGTH,DATA_FREE,AUTO_INCREMENT,CREATE_TIME,UPDATE_TIME,CHECK_TIME,TABLE_COLLATION,CHECKSUM,CREATE_OPTIONS,TABLE_COMMENT
def,db1,names,BASE TABLE,InnoDB,10,Compact,0,0,16384,0,0,0,NULL,NULL,NULL,NULL,latin1_swedish_ci,NULL,,
$ query-rds-data "select * from db1.names" --db-cluster-identifier demo
id,name
1,Bruce
$ query-rds-data "select * from db1.names" --db-user-identifier admin
id,name
1,Bruce
$ query-rds-data "select * from db1.names" --db-cluster-identifier demo --db-user-identifier admin
id,name
1,Bruce
$ query-rds-data "select * from db1.names" --db-cluster-identifier nope
Error: No DB matched "nope", available ids are ["demo"]
$ query-rds-data "select * from db1.names" --db-user-identifier fake
Error: No DB user matched "fake", available users are ["admin"]
$ query-rds-data "select * from db1.names"
Error: Multiple DBs found, please specify one of ["demo", "empty"]
$ query-rds-data "select * from db1.names" --db-cluster-identifier demo
Error: Multiple DB users found, please specify one of ["admin", "read_only"]
$ query-rds-data "select * from db1.names" --db-cluster-identifier demo --db-user-identifier read_only
id,name
1,Bruce