What is MIME type "text/x-tsql"?

A MIME type is a string that tells browsers and other tools how to handle a particular kind of file.

text/x-tsql designates plain text files that hold Transact-SQL code. These files contain SQL commands and scripts used to interact with databases.
They are often opened with text editors or integrated into development environments that offer syntax highlighting and code assistance for T-SQL.
The format is especially common in environments like Microsoft SQL Server, where robust scripting is key.
The file type is associated with the SQL format.

Use Case: Writing and running database scripts and queries.
Functionality: Helps text editors and IDEs recognize T-SQL syntax for better code support.
Key Fact: It signals that the content should be treated as plain text with T-SQL structures.

Additional resources on MIME types and T-SQL details can be found at IANA Media Types and the official T-SQL Documentation.

Associated file extensions

.sql

Usage Examples

HTTP Header

When serving content with this MIME type, set the Content-Type header:


    Content-Type: text/x-tsql

HTML

In HTML, you can specify the MIME type in various elements:


    <a href="file.dat" type="text/x-tsql">Download file</a>

Server-side (Node.js)

Setting the Content-Type header in Node.js:


    const http = require('http');    
    
    http.createServer((req, res) => {    
      res.setHeader('Content-Type', 'text/x-tsql');    
      res.end('Content here');    
    }).listen(3000);

Associated file extensions

.sql

FAQs

What is the text/x-tsql MIME type used for?

The text/x-tsql MIME type specifically identifies files containing Transact-SQL (T-SQL) code, which is Microsoft's proprietary extension to SQL. Unlike generic SQL types, this tells editors and IDEs to apply syntax highlighting specific to T-SQL keywords and functions used in Microsoft SQL Server.

How do I open a file sent as text/x-tsql?

Since T-SQL files are plain text, you can open them with any basic text editor like Notepad or TextEdit. for the best experience, use specialized tools like SQL Server Management Studio (SSMS) or Visual Studio Code, which provide code completion and execution features for the .sql extension.

Is text/x-tsql a standard MIME type?

No, the x- prefix indicates that it is a non-standard or experimental type, not officially registered with the IANA. While standard SQL might use application/sql or text/plain, text/x-tsql is widely used in development environments to distinguish Microsoft T-SQL scripts from other database dialects.

How do I configure Apache to serve .sql files as text/x-tsql?

You can map the extension in your .htaccess file or main configuration. Add the line AddType text/x-tsql .sql to ensure the server sends the correct Content-Type header. This helps client applications recognize the content as T-SQL rather than generic text.

Why does my browser download .sql files instead of displaying them?

Most web browsers do not have a built-in rendering engine for SQL code, so they default to downloading the file. If you want the browser to attempt to display it as text, you may need to set the Content-Disposition header to inline or serve the file as text/plain, though this loses the T-SQL semantic distinction.

Are there security risks in serving text/x-tsql files publicly?

Yes, extreme caution is advised. T-SQL files often contain database schemas, table names, or even stored procedure logic that can help attackers exploit your database. generally, these files should not be accessible via a public URL unless intended for educational code sharing.

General FAQ

What is a MIME type?

A MIME (Multipurpose Internet Mail Extensions) type is a standard that indicates the nature and format of a document, file, or assortment of bytes. MIME types are defined and standardized in IETF's RFC 6838.

MIME types are important because they help browsers and servers understand how to process a file. When a browser receives a file from a server, it uses the MIME type to determine how to display or handle the content, whether it's an image to display, a PDF to open in a viewer, or a video to play.

MIME types consist of a type and a subtype, separated by a slash (e.g., text/html, image/jpeg, application/pdf). Some MIME types also include optional parameters.

How do I find the MIME type for a file?

You can check the file extension or use a file identification tool such as file --mime-type on the command line. Many programming languages also provide libraries to detect MIME types.

Why are multiple MIME types listed for one extension?

Different applications and historical conventions may use alternative MIME identifiers for the same kind of file. Showing them all helps ensure compatibility across systems.