Database modules

Aerospike

• aerospike_migrations – Check or wait for migrations between nodes

Influxdb

• influxdb_database – Manage InfluxDB databases

• influxdb_query – Query data points from InfluxDB

• influxdb_retention_policy – Manage InfluxDB retention policies

• influxdb_user – Manage InfluxDB users

• influxdb_write – Write data points into InfluxDB

Misc

• elasticsearch_plugin – Manage Elasticsearch plugins

• kibana_plugin – Manage Kibana plugins

• redis – Various redis commands, slave and flush

• riak – This module handles some common Riak operations

Mongodb

• mongodb_parameter – Change an administrative parameter on a MongoDB server

• mongodb_replicaset – Initialises a MongoDB replicaset

• mongodb_shard – Add and remove shards from a MongoDB Cluster

• mongodb_user – Adds or removes a user from a MongoDB database

Mssql

• mssql_db – Add or remove MSSQL databases from a remote host

Mysql

• mysql_db – Add or remove MySQL databases from a remote host

• mysql_info – Gather information about MySQL servers

• mysql_replication – Manage MySQL replication

• mysql_user – Adds or removes a user from a MySQL database

• mysql_variables – Manage MySQL global variables

Postgresql

• postgresql_copy – Copy data between a file/program and a PostgreSQL table

• postgresql_db – Add or remove PostgreSQL databases from a remote host

• postgresql_ext – Add or remove PostgreSQL extensions from a database

• postgresql_idx – Create or drop indexes from a PostgreSQL database

• postgresql_info – Gather information about PostgreSQL servers

• postgresql_lang – Adds, removes or changes procedural languages with a PostgreSQL database

• postgresql_membership – Add or remove PostgreSQL roles from groups

• postgresql_owner – Change an owner of PostgreSQL database object

• postgresql_pg_hba – Add, remove or modify a rule in a pg_hba file

• postgresql_ping – Check remote PostgreSQL server availability

• postgresql_privs – Grant or revoke privileges on PostgreSQL database objects

• postgresql_publication – Add, update, or remove PostgreSQL publication

• postgresql_query – Run PostgreSQL queries

• postgresql_schema – Add or remove PostgreSQL schema

• postgresql_sequence – Create, drop, or alter a PostgreSQL sequence

• postgresql_set – Change a PostgreSQL server configuration parameter

• postgresql_slot – Add or remove replication slots from a PostgreSQL database

• postgresql_table – Create, drop, or modify a PostgreSQL table

• postgresql_tablespace – Add or remove PostgreSQL tablespaces from remote hosts

• postgresql_user – Add or remove a user (role) from a PostgreSQL server instance

Proxysql

• proxysql_backend_servers – Adds or removes mysql hosts from proxysql admin interface

• proxysql_global_variables – Gets or sets the proxysql global variables

• proxysql_manage_config – Writes the proxysql configuration settings between layers

• proxysql_mysql_users – Adds or removes mysql users from proxysql admin interface

• proxysql_query_rules – Modifies query rules using the proxysql admin interface

• proxysql_replication_hostgroups – Manages replication hostgroups using the proxysql admin interface

• proxysql_scheduler – Adds or removes schedules from proxysql admin interface

Vertica

• vertica_configuration – Updates Vertica configuration parameters

• vertica_info – Gathers Vertica database facts

• vertica_role – Adds or removes Vertica database roles and assigns roles to them

• vertica_schema – Adds or removes Vertica database schema and roles

• vertica_user – Adds or removes Vertica database users and assigns roles

Note

• (D): This marks a module as deprecated, which means a module is kept for backwards compatibility but usage is discouraged. The module documentation details page may explain more about this rationale.