--- title: "Streamline Your Data Management for Non-Production with Washery: A Tool for Amazon RDS" description: Learn how Washery, a tool by base2Services, streamlines data management for Amazon RDS. Clean, anonymise and transfer datasets securely within your AWS account. image: https://blog.base2services.com/hubfs/Blog%20Thumbnails/Blog%20Feature%20Update%20v1.jpg --- [![base2Services - The Cloud Services People](https://www.base2services.com/images/base2.svg)](https://www.base2services.com/) - [Solutions](https://www.base2services.com/services/) - Get Started Here - [KickOff](https://www.base2services.com/products/kickoff/) - [Secure Compass](https://www.base2services.com/products/securecompass/) - [Focused AWS Review](https://www.base2services.com/consulting/services/discovery-and-review/) - Managed Services - [Cloud Management](https://www.base2services.com/cloudmanagement/) - [Platform Engineering](https://www.base2services.com/platform-engineering/) - [Compliance & Risk](https://www.base2services.com/security/) - Bundled Engagement - [DevOps as a Service](https://www.base2services.com/devops/) - [Prototype to Production](https://www.base2services.com/prototype-to-production/) - Specialist Engagements - [Migration](https://www.base2services.com/consulting/services/cloud-migration/) - [AI Factory](https://www.base2services.com/artificialintelligence/aifactory/) - [Generative AI](https://www.base2services.com/artificialintelligence/generativeai/) - [SaaS CTO](https://www.base2services.com/consulting/services/saas-cto/) - [Industries](https://www.base2services.com/industries/) - [SaaS & ISVs](https://www.base2services.com/industries/saas-and-isvs/) - [Financial Services](https://www.base2services.com/industries/financial-services/) - [Healthcare & Life Sciences](https://www.base2services.com/industries/healthcare-and-life-sciences/) - [Government & Enterprise](https://www.base2services.com/industries/government-and-enterprise/) - [Media](https://www.base2services.com/industries/media/) - [Education](https://www.base2services.com/industries/education/) - [AWS Advanced Partner](https://www.base2services.com/partners/partner-pages/aws.html) - [AWS DevOps Competency](https://www.base2services.com/partners/partner-pages/aws.html) - [AWS SaaS Competency](https://www.base2services.com/aws-saas-solutions/index.html) - [Enablement Tools](https://www.base2services.com/partners/) - [Explore](https://www.base2services.com/community/) - [Blog](https://blog.base2services.com) - [Videos](https://www.base2services.com/community/videos/) - Toolkit - [Cloud Monitoring](https://www.base2services.com/products/cloud-monitoring-aws/) - [Start/Stop](https://www.base2services.com/products/start-stop-aws/) - [Safe Test Data](https://www.base2services.com/products/safe-test-data/) - [App Configuration](https://www.base2services.com/products/application-config/) - [Secure Access](https://www.base2services.com/products/secure-access-aws/) - [Ask about AWS](https://www.base2services.com/products/ai-access-aws/) - [Resource Documenter](https://www.base2services.com/products/resource-documenter/) - [Talk to Us](https://www.base2services.com/contact/) - [About](https://www.base2services.com/about/) - [About Us](https://www.base2services.com/about/) - [Why Choose Us](https://www.base2services.com/how-we-work/why-choose-us/) - [How We Work](https://www.base2services.com/how-we-work/) - [Case Studies](https://www.base2services.com/customers/) - [Solutions](https://www.base2services.com/services/) ##### Get Started Here - [KickOff](https://www.base2services.com/products/kickoff/) - [Secure Compass](https://www.base2services.com/products/securecompass/) - [Focused AWS Review](https://www.base2services.com/consulting/services/discovery-and-review/) ##### Managed Services - [Cloud Management](https://www.base2services.com/cloudmanagement/) - [Platform Engineering](https://www.base2services.com/platform-engineering/) - [Compliance & Risk](https://www.base2services.com/security/) ##### Bundled Engagement - [DevOps as a Service](https://www.base2services.com/devops/) - [Prototype to Production](https://www.base2services.com/prototype-to-production/) ##### Specialist Engagements - [Migration](https://www.base2services.com/consulting/services/cloud-migration/) - [AI Factory](https://www.base2services.com/artificialintelligence/aifactory/) - [Generative AI](https://www.base2services.com/artificialintelligence/generativeai/) - [SaaS CTO](https://www.base2services.com/consulting/services/saas-cto/) - [Industries](https://www.base2services.com/industries/) - [SaaS & ISVs](https://www.base2services.com/industries/saas-and-isvs/) - [Financial Services](https://www.base2services.com/industries/financial-services/) - [Healthcare & Life Sciences](https://www.base2services.com/industries/healthcare-and-life-sciences/) - [Government & Enterprise](https://www.base2services.com/industries/government-and-enterprise/) - [Media](https://www.base2services.com/industries/media/) - [Education](https://www.base2services.com/industries/education/) - More - [AWS Advanced Partner](https://www.base2services.com/partners/partner-pages/aws.html) - [Explore](https://www.base2services.com/community/) - [About Us](https://www.base2services.com/about/) - [Case Studies](https://www.base2services.com/customers/) - [AWS Advanced Partner](https://www.base2services.com/partners/partner-pages/aws.html) - [AWS DevOps Competency](https://www.base2services.com/partners/partner-pages/aws.html) - [AWS SaaS Competency](https://www.base2services.com/aws-saas-solutions/index.html) - [Amazon Foundational Technical Review](https://www.base2services.com/consulting/amazon-foundational-technical-review-ftr/index.html) - [Other partners](https://www.base2services.com/partners/) - [Explore](https://www.base2services.com/community/) - [Blog](https://blog.base2services.com) - [Videos](https://www.base2services.com/community/videos/) - Toolkit - [Cloud Monitoring](https://www.base2services.com/products/cloud-monitoring-aws/) - [Start/Stop](https://www.base2services.com/products/start-stop-aws/) - [Safe Test Data](https://www.base2services.com/products/safe-test-data/) - [App Configuration](https://www.base2services.com/products/application-config/) - [Secure Access](https://www.base2services.com/products/secure-access-aws/) - [Ask about AWS](https://www.base2services.com/products/ai-access-aws/) - [Resource Documenter](https://www.base2services.com/products/resource-documenter/) - [About](https://www.base2services.com/about/) - [About Us](https://www.base2services.com/about/) - [Why Choose Us](https://www.base2services.com/how-we-work/why-choose-us/) - [How We Work](https://www.base2services.com/how-we-work/) - [Case Studies](https://www.base2services.com/customers/) - - [Search](https://www.base2services.com/search.html) - [Talk to Us](https://www.base2services.com/contact/) [1300 713 559](tel:1300713559) [646 586 9485](tel:3474670942) [← Blogs](https://blog.base2services.com/) [Tech](https://blog.base2services.com/tag/tech) [Tools](https://blog.base2services.com/tag/tools) # Streamline Your Data Management for Non-Production with Washery: A Tool for Amazon RDS ![Michael Shelton](https://blog.base2services.com/hs-fs/hubfs/Headshots/MWR56217%20-%20HS_Author.jpg?width=100) Michael Shelton · 2 Minute Read Share [in](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fblog.base2services.com%2Fstreamline-your-data-management-with-washery-a-tool-for-amazon-rds) [X](https://twitter.com/intent/tweet?url=https%3A%2F%2Fblog.base2services.com%2Fstreamline-your-data-management-with-washery-a-tool-for-amazon-rds&text=%3Cspan+id%3D%22hs_cos_wrapper_name%22+class%3D%22hs_cos_wrapper+hs_cos_wrapper_meta_field+hs_cos_wrapper_type_text%22+style%3D%22%22+data-hs-cos-general-type%3D%22meta_field%22+data-hs-cos-type%3D%22text%22+%3EStreamline+Your+Data+Management+for+Non-Production+with+Washery%3A+A+Tool+for+Amazon+RDS%3C%2Fspan%3E) [f](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fblog.base2services.com%2Fstreamline-your-data-management-with-washery-a-tool-for-amazon-rds) [↗](mailto:?subject=%3Cspan+id%3D%22hs_cos_wrapper_name%22+class%3D%22hs_cos_wrapper+hs_cos_wrapper_meta_field+hs_cos_wrapper_type_text%22+style%3D%22%22+data-hs-cos-general-type%3D%22meta_field%22+data-hs-cos-type%3D%22text%22+%3EStreamline+Your+Data+Management+for+Non-Production+with+Washery%3A+A+Tool+for+Amazon+RDS%3C%2Fspan%3E&body=https%3A%2F%2Fblog.base2services.com%2Fstreamline-your-data-management-with-washery-a-tool-for-amazon-rds) Managing and securing database information across different environments is not just crucial—it's a requirement. Recognizing this need, we have developed Washery, a robust tool designed to streamline the management and manipulation of datasets stored in Amazon RDS (Relational Database Services). As a managed database service offered by AWS, Amazon RDS handles a significant amount of sensitive data, which often requires meticulous handling, especially when transferring between different environments like production and non-production. ## Why Washery? Washery is not just a tool; it's a solution designed to address the challenges of managing sensitive data in non-production environments. By automating the cleaning and dumping processes, it significantly reduces manual efforts and potential errors, ensuring that developers and testers work with data that mirrors production quality without risking privacy or security. Once the data is cleaned, Washery facilitates its transfer by either creating a new, clean snapshot or dumping the anonymized data into an Amazon S3 bucket for storage. ## How Washery works: - **Snapshot and Database Details Retrieval:** Initially, Washery retrieves details about the existing snapshots, database types, and versions from RDS. - **Scrub/Dump/Restore Stack Creation:** It uses AWS CloudFormation to deploy the necessary stack for data scrubbing, dumping, or restoring operations. - **Execution in Secure Environment**: Washery operates in a secure runtime environment on AWS Fargate, where the main scrubbing or dumping scripts are executed. - **Data Scrubbing and Dumping:** Depending on the operation: - **Scrubbing**: A custom scrubbing script is applied to the restored database snapshot, ensuring all sensitive data is anonymized. - **Dumping**: The cleaned data is then dumped into an S3 bucket, effectively backing it up in a secure and compliant manner. - **Optional Snapshot Creation:** Post-processing, an optional snapshot of the cleaned data can be created for further use. - **Environment Teardown:** Finally, the environment is cleanly torn down via CloudFormation, ensuring no residual data or resources are left. ## Advantages of Using Washery: - **Security and Compliance:** Washery operates securely within your AWS account, using isolated resources and generating random passwords to safeguard access. - **Efficiency:** Automating the data cleaning and dumping process reduces manual labor and potential human error, speeding up the data management processes for non-production environments. - **Flexibility:** With the capability to handle various types of database setups within RDS, Washery is adaptable to a wide range of data management needs. By integrating Washery into your data management strategy, you can ensure that your non-production environments are using data that is clean, compliant, and reflective of your production setups, without compromising data security or privacy. Washery is available to all base2Services' customers as part of our [ongoing services](https://www.base2services.com/devops/). Contact us to find out more #### Stay in the loop ### DevOps & AI insights, straight to your inbox Our best content, services and events. Roughly every second month. ### Keep reading #### [devops AWS · Cloud · Tech · AI Unlocking Enterprise Knowledge with Amazon Kendra and AI](https://blog.base2services.com/unlocking-enterprise-knowledge-with-amazon-kendra-and-ai) #### [devops Automation · Tech · AI · featured Knowing What Is Running Is Not the Same as Knowing Why](https://blog.base2services.com/knowing-what-is-running-is-not-the-same-as-knowing-why) #### [devops Security · Tech · AI AI Tools Are Entering Your Business Faster Than Anyone Can Vet Them](https://blog.base2services.com/ai-tools-are-entering-your-business-faster-than-anyone-can-vet-them) #### [devops AWS · Serverless · Tech AWS Lambda Managed Instances: Why This Changes the Serverless vs EC2 Conversation](https://blog.base2services.com/aws-lambda-managed-instances) ## Send an enquiry Tell us about your environment, a project in flight or a problem you are trying to solve. - For regulated, SaaS and product teams on AWS - No pitch deck, a practical conversation first Or book a time that suits you [Book a 30-minute chat](https://info.base2services.com/meetings/m-shelton/contact-us) [![base2Services](https://www.base2services.com/images/base2_white.svg)](https://www.base2services.com/) base2Services is an ISO 27001:2022 certified AWS managed services partner, running platform engineering, cloud operations, AI operations and compliance for SaaS companies, ISVs and regulated software teams since 2005. ### Get Started Here - [KickOff](https://www.base2services.com/products/kickoff/) - [Secure Compass](https://www.base2services.com/products/securecompass/) - [Focused AWS Review](https://www.base2services.com/consulting/services/discovery-and-review/) ### Managed Services - [Cloud Management](https://www.base2services.com/cloudmanagement/) - [Platform Engineering](https://www.base2services.com/platform-engineering/) - [Compliance & Risk](https://www.base2services.com/security/) - [DevOps as a Service](https://www.base2services.com/devops/) ### Specialist Engagements - [Prototype to Production](https://www.base2services.com/prototype-to-production/) - [Migration](https://www.base2services.com/consulting/services/cloud-migration/) - [AI Factory](https://www.base2services.com/artificialintelligence/aifactory/) - [Generative AI](https://www.base2services.com/artificialintelligence/generativeai/) - [SaaS CTO](https://www.base2services.com/consulting/services/saas-cto/) ### Toolkit - [Cloud Monitoring](https://www.base2services.com/products/cloud-monitoring-aws/) - [Start/Stop](https://www.base2services.com/products/start-stop-aws/) - [Safe Test Data](https://www.base2services.com/products/safe-test-data/) - [App Configuration](https://www.base2services.com/products/application-config/) - [Secure Access](https://www.base2services.com/products/secure-access-aws/) - [Ask about AWS](https://www.base2services.com/products/ai-access-aws/) - [Resource Documenter](https://www.base2services.com/products/resource-documenter/) ### Company - [About Us](https://www.base2services.com/about/) - [Customers](https://www.base2services.com/customers/) - [How We Work](https://www.base2services.com/how-we-work/) - [Why Choose Us](https://www.base2services.com/how-we-work/why-choose-us/) - [Explore](https://www.base2services.com/community/) - [Blog](https://blog.base2services.com/) - [Videos](https://www.base2services.com/community/videos/) ![ISO 27001 Certified](https://www.base2services.com/images/ISO-27001-certified_white.svg) [![JASANZ Certified](https://www.base2services.com/images/jasanz.svg)](https://register.jas-anz.org/certified-organisations) © base2Services | [Terms & Conditions](https://www.base2services.com/community/terms.html) | [Privacy](https://www.base2services.com/community/privacy.html) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Michael Shelton", "url" : "https://blog.base2services.com/author/michael-shelton" }, "dateModified" : "2025-02-14T09:06:24.229Z", "datePublished" : "2024-07-24T17:13:00.000Z", "headline" : "Streamline Your Data Management for Non-Production with Washery: A Tool for Amazon RDS", "image" : [ "https://blog.base2services.com/hubfs/Blog%20Thumbnails/Blog%20Feature%20Update%20v1.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.base2services.com/streamline-your-data-management-with-washery-a-tool-for-amazon-rds", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.base2services.com/hubfs/B2S_logo_600x400px.png" }, "name" : "base2Services" } } ```