Skip to content

crosbymichael/dockersql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

dockersql

Query your docker with SQL. Why? Why not.

Connect to your docker

dockersql --docker http://docker:2375

Get the count of all images

dockersql
> select count(*) from images;
count(*)
25
>

Select all images larger than 1G

dockersql
> select * from images where virtual_size > 1024*1024*1024
id                                                                 parent_id                                                          size       virtual_size   tag
8803adbf8f9c90dd66c146651401aab40a1c12cdbb6fb5bd3934c4ad6f05389d   e16a6ea01ac787c7bebdd73c92037a4fa9ca2bd61979ba00d1831d535aefdaf2   55810869   1196777592     docker:latest
f2505178b040558983f5a54ec32119d1407b68aa936be4942d5a41a199befaf2   e16a6ea01ac787c7bebdd73c92037a4fa9ca2bd61979ba00d1831d535aefdaf2   59775724   1200742447     release:latest
>

Join containers and images

dockersql
> SELECT c.id, c.name, c.image FROM containers AS c JOIN images AS i ON c.image=i.tag
id                                                                 name              image
3481862d9bb6e0fd9ad4d951faa7ebf9a477a0194975fb1698a1d3e9691c7935   /redis            crosbymichael/redis:latest
f733305c31fd3e7ea7269a96ff1747f977ee5a19decf8b4778a481a010434a0c   /local-registry   registry:latest
>

License - MIT

About

Query your docker via SQL

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published