I daily use Pycharm as my primary python IDE. My projects use Boto (Amazon Python SDK) to access Amazon DynomoDB and Amazon RDS. Does any one has experience to make Pycharm works with Amazon's Database service?
I think if I can view and show table content of RDS and search the data of DynomoDB directly from Pycharm would be pretty neat.
Yes you can connect to AWS databases using boto through Pycharm. Try these codes to access the Redshift, Elastic Cache and RDS.
#Accessing RDS rds_sg = conn2.get_all_dbinstances() for r in rds_sg: #print r # Redshift redshift_sg = conn3.describe_clusters() for cluster_group in redshift_sg['DescribeClustersResponse']['DescribeClustersResult']['Clusters']: #print cluster_group # ElasticCache list_of_clusters =  elastic_sg = conn4.describe_cache_clusters() list_of_clusters.append(elastic_sg['DescribeCacheClustersResponse']['DescribeCacheClustersResult']['CacheClusters']) for clusters in list_of_clusters: #print clusters
By this, you can access the databases of AWS console.