> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Table of Contents page for Settings

# Settings

{/*AUTOGENERATED_START*/}

| Page                                                                                           | Description                                                                                                                                                                       |
| ---------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [Settings Overview](/concepts/features/configuration/settings/overview)                        | Overview page for settings.                                                                                                                                                       |
| [Permissions for queries](/concepts/features/configuration/settings/permissions-for-queries)   | Settings for query permissions.                                                                                                                                                   |
| [Restrictions on query complexity](/concepts/features/configuration/settings/query-complexity) | Settings which restrict query complexity.                                                                                                                                         |
| [Settings profiles](/concepts/features/configuration/settings/settings-profiles)               | A collection of settings grouped under the same name.                                                                                                                             |
| [Constraints on settings](/concepts/features/configuration/settings/constraints-on-settings)   | Constraints on settings can be defined in the `profiles` section of the `user.xml` configuration file and prohibit users from changing some of the settings with the `SET` query. |
| [Users and roles settings](/concepts/features/configuration/settings/settings-users)           | Settings for configuring users and roles.                                                                                                                                         |
| [Composable protocols](/concepts/features/configuration/server-config/composable-protocols)    | Composable protocols allows more flexible configuration of TCP access to the ClickHouse server.                                                                                   |
| [Format Settings](/reference/settings/formats)                                                 | Settings which control input and output formats.                                                                                                                                  |
| [Memory overcommit](/concepts/features/configuration/settings/memory-overcommit)               | An experimental technique intended to allow to set more flexible memory limits for queries.                                                                                       |
| [MergeTree tables settings](/reference/settings/merge-tree-settings)                           | Settings for MergeTree which are in `system.merge_tree_settings`                                                                                                                  |
| [Query-level Session Settings](/concepts/features/configuration/settings/settings-query-level) | Settings at the query-level                                                                                                                                                       |
| [Server overload](/concepts/features/configuration/settings/server-overload)                   | Controlling behavior on server CPU overload.                                                                                                                                      |
| [Session Settings](/reference/settings/session-settings)                                       | Settings which are found in the `system.settings` table.                                                                                                                          |
| [TCP connection limits](/concepts/features/configuration/settings/tcp-connection-limits)       | TCP connection limits.                                                                                                                                                            |