# Enabling GraphQL for Columns in QueryDeck

QueryDeck allows you to control which database columns are exposed via GraphQL, ensuring that only necessary data is available through API queries. This enhances security, improves performance, and keeps your API responses clean.

***

### **Steps to Enable GraphQL for Columns in QueryDeck**

1. **Navigate to the GraphQL Section**

   * Open the QueryDeck app you want to edit

   <figure><img src="https://1803924624-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkjtTl1rn3hJ3jyoJt6ty%2Fuploads%2FAd74xw3LEk6njN2kZVDI%2FScreenshot%202025-02-13%20at%201.06.33%E2%80%AFPM.png?alt=media&#x26;token=fc331cf0-0890-42bd-b6e3-5a21f4266b67" alt=""><figcaption></figcaption></figure>

* Go to the **GraphQL** tab.

<figure><img src="https://1803924624-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkjtTl1rn3hJ3jyoJt6ty%2Fuploads%2FLumwGgRzS4Ovs5uyrOul%2Fimage.png?alt=media&#x26;token=3de7d40a-e56f-4dab-adf5-69f398f7608a" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1803924624-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkjtTl1rn3hJ3jyoJt6ty%2Fuploads%2FaP4PqyOzLbzpT97V8LOp%2FScreenshot%202025-02-13%20at%201.08.34%E2%80%AFPM.png?alt=media&#x26;token=dacab288-aa0a-4542-8e5e-d32fdd96e5a7" alt=""><figcaption></figcaption></figure>

* Select the table for which you want to enable GraphQL access by clicking on the "+" button

<figure><img src="https://1803924624-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkjtTl1rn3hJ3jyoJt6ty%2Fuploads%2FUFZHXu75DzMKaezWwZAF%2Fimage.png?alt=media&#x26;token=670f5fb7-92f0-475d-91ba-a4b435c7f0e4" alt=""><figcaption></figcaption></figure>

**Select the Columns to Expose**

* Click on the **Columns**  dropdown  for the selected table.

<figure><img src="https://1803924624-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkjtTl1rn3hJ3jyoJt6ty%2Fuploads%2FkQyyqCilckLNMU7f8Lw1%2Fimage.png?alt=media&#x26;token=bd4da6b9-2350-44d0-be02-3be77cea4a38" alt=""><figcaption></figcaption></figure>

* A popup will appear listing all the columns in the table, select ur desired columns.

<figure><img src="https://1803924624-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkjtTl1rn3hJ3jyoJt6ty%2Fuploads%2FHj6eSZueJDGv25NAJP4L%2Fimage.png?alt=media&#x26;token=9e9b144d-9305-4699-b741-cefb221b7cc9" alt=""><figcaption></figcaption></figure>

After selecting the required columns, click **Save** to apply the changes.

<figure><img src="https://1803924624-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkjtTl1rn3hJ3jyoJt6ty%2Fuploads%2Fy91hplFlcWL2osxcb844%2Fimage.png?alt=media&#x26;token=95f2a706-99dc-4177-b72a-65ee3c75019a" alt=""><figcaption></figcaption></figure>

***

### **Security Considerations**

* **Restrict Access to Sensitive Columns:** Disable GraphQL access for fields like passwords, payment details, or internal metadata.
* **Role-Based Access:** Use QueryDeck’s authentication and authorization settings to control column visibility based on user roles.