Reputation: 2910

SimpleDB Manager

anyone know a decent SimpleDB Manager Tool, web-based or Mac, preferably free? I am surprised AWS doesn't have one built-in.

Upvotes: 13

Answers (7)

ryanman

Reputation: 3844

The tool that ended up working best for me was the SimpleDB management as part of the aws sdk for eclipse.

Even if you're not using eclipse for development, it's a simple install in order to just use it for SimpleDb management. Instructions:

eclipse install here
aws toolkit install here.

When choosing the components in the eclipse "available software" dialog, just pick these 2:

AWS Toolkit for Eclipse Core
Amazon SimpleDB Management

Once installed, show the AWS Explorer view (Window->Show View->Other and type 'aws'). It'll prompt you for your aws credentials. In the AWS Explorer view, you'll see Amazon SimpleDB in the tree.

This tool let's you:

Choose a region
Create/delete domains
Query the domain
Edit items
Export data to .csv
View domain metadata, like item count and total size

Upvotes: 1

Ashish Pancholi

Reputation: 4659

You can use SDB Explorer. SDB Explorer provides an industry-leading and intuitive Graphical User Interface (GUI) to explore Amazon SimpleDB service in a thorough manner, and in a very efficient and user friendly way.

You can download and use SDB Explorer free for 30 days. The free version will stop working after 30 days if it isn't activated with a paid license key. It has many features like..

CSV Export/Import.
Experience fast, Multiple and parallel operartions.
Quick Search on Amazon SimpleDB Domain.
In-place cell editing.
Upload My-SQL data to Amazon SimpleDB.
AWS IAM interface to manage users, groups, polices and credentials for Amazon SimpleDB service.
Easy Listing of Domains from all Region End Points supported by Amazon SimpleDB.
Execute Queries like in any standard Database Query Tool.
Support for MAC/Linux/Windows platform.
On-line Help, Documentation, Demos, Screen shots, Discussion forums and Product Support.

http://www.sdbexplorer.com/

Upvotes: 1

stuckintheshuck

Reputation: 2529

Unfortunately there aren't any really well done SimpleDB Managers. I've used Scratchpad, SDB Explorer, and the SdbNavigator chrome extension. All have limitations. Don't waste your time on Scratchpad or your money on SDB Explorer - SdbNavigator is free and works better.

Personally I use SdbNavigator to run ad-hoc queries and small deletes. For most everything else I write simple Python scripts using Boto.

I haven't found anything that does multi-value attribute fields so it is best to just script it for now.

If you've got an IPad, I recommend CloudBase for managing SimpleDB and running queries. It's nice because you can save queries which reduces unnecessary typing.

Upvotes: 4

Paul Weber

Reputation: 6708

If for some reason the SDBNavigator Crome Plugin mentioned in another answer is not applicable for you, the tool RazorSQL also supports SimpleDB. It is not free though, and a Java Application.

Upvotes: 1