Methods for public cloud database activity monitoring and devices thereof

A database activity monitor device, comprising memory comprising programmed instructions stored thereon and one or more processors configured to execute the stored programmed instructions to:

• deploy a monitoring proxy into a virtual private cloud (VPC) network hosted by a first public cloud network following detection in the VPC network of a new database associated with an entity;
• receive activity data from the monitoring proxy and record the activity data in a repository, wherein the monitoring proxy is configured to obtain and report the activity data based on a first database type of the new database;
• determine when at least one security check defined in at least one security policy is violated based on an analysis of the activity data;
• automatically output an alert via a communication network, when the determination indicates the security check is violated;
• and
• generate and output one or more interactive dashboards based on the activity data, wherein the interactive dashboards comprise a historical database activity report for the entity.

A non-transitory computer readable medium having stored thereon instructions for public cloud database activity monitoring comprising executable code that, when executed by one or more processors, causes the processors to:

• deploy a monitoring proxy into a virtual private cloud (VPC) network hosted by a first public cloud network following detection in the VPC network of a new database associated with an entity;
• receive activity data from the monitoring proxy and record the activity data in a repository, wherein the monitoring proxy is configured to obtain and report the activity data based on a first database type of the new database;
• determine when at least one security check defined in at least one security policy is violated based on an analysis of the activity data;
• automatically output an alert via a communication network, when the determination indicates the security check is violated;
• and
• generate and output one or more interactive dashboards based on the activity data, wherein the interactive dashboards comprise a historical database activity report for the entity.