---
title: "Creating a Microsoft SQL Tag"
slug: "creating-a-microsoft-sql-tag"
updated: 2024-09-24T15:21:36Z
published: 2024-09-24T15:21:36Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ai-op.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating a Microsoft SQL Tag

After [creating a tag](/v1/docs/adding-a-device-general) and selecting an Microsoft SQL device, you will be expected to fill out the following fields:

![](https://cdn.document360.io/9fab5c8f-2756-48da-b963-232bd8533649/Images/Documentation/image(66).png)

#### SQL Query

Query string sent to the Microsoft SQL server.

##### Query Behavior

When a query is made successfully, Koios grabs the first column of the first row. Please ensure that you are only returning a single row and that the desired value is in the first column.

> [!NOTE]
> **Read Only**
> 
> Koios currently only supports SQL reads. An output tag cannot be used to write back to the database.

##### Disallowed Words

As an attempt to prevent an accidental SQL injection, the following words are disallowed in the query string:

- DELETE
- CREATE
- ALTER
- DEFAULT
- DROP
- DATABASE
- SET
- TRUNCATE TABLE
- UPDATE

> [!WARNING]
> Testing
> 
> Please be cautious using the SQL protocol, test your queries thoroughly to ensure there is no unintended consequences.