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.

A free tool (Google Chrome plugin) is available at https://chrome.google.com/webstore/detail/ddhigekdfabonefhiildaiccafacphgg?hc=search&hcp=main

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.

Amazon makes this tool available as a sample. Javascript Scratchpad for Amazon SimpleDB

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.

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..

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

http://www.sdbexplorer.com/

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

Check out SDB Tool, a great Firefox plugin. It's free and I've never had a problem.