KSQL - A simple tool for interactive database queries on Kubernetes resources.
Prerequisites:
npm install q
npm install alasql
npm install node-kubernetes-client
npm install readline-history
npm install cli-table2
npm install js-yaml
Running:
kubectl proxy &
node ksql.js
Example Queries:
select count(*) from containers where containers.image like 'mysql%'
select count(*),image from containers where containers.image like 'mysql%' group by image
select pods.metadata->name,pods.metadata->annotations->email,image from pods join containers using uid where image like 'mysql:5.5%'
select pods.metadata->name,image from pods left join containers using uid where image like 'mysql%' and not pods.metadata->annotations->email