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.