Database modules
Aerospike
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
Mysql
- mysql_db – Add or remove MySQL databases from a remote host
- mysql_replication – Manage MySQL replication
- mysql_user – Adds or removes a user from a MySQL database
- mysql_variables – Manage MySQL global variables
Postgresql
- 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_query – Run PostgreSQL queries
- postgresql_schema – Add or remove PostgreSQL schema
- postgresql_set – Change a PostgreSQL server configuration parameter
- postgresql_slot – Add or remove 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_facts – 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.
© 2012–2018 Michael DeHaan
© 2018–2019 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.8/modules/list_of_database_modules.html