Logo

SQL to Textile Converter

Transform SQL database dumps into Textile table markup format for Redmine, Textpattern, and other Textile-based content management systems

SQL Input

Convert SQL to other formats

SQL to ActionScriptSQL to ASCIISQL to AsciiDocSQL to ASPSQL to AvroSQL to BBCodeSQL to CSVSQL to DAX

Textile Output

Convert other formats to Textile

CSV to TextileExcel to TextileHTML to TextileJSON to TextileLaTeX to TextileMarkdown to TextileMediaWiki to TextileMySQL to Textile

Related Tools

SQL to TOML

Convert SQL CREATE TABLE and INSERT statements to TOML configuration format for Rust and Python

SQL to TracWiki

Convert SQL CREATE TABLE and INSERT statements to Trac Wiki table markup for project management

SQL to XML

Convert SQL CREATE TABLE and INSERT statements to XML format with customizable element names

SQL to YAML

Convert SQL CREATE TABLE and INSERT statements to YAML format for Kubernetes and Docker Compose

XML to ActionScript

Convert XML data to ActionScript arrays, vectors, and objects with type detection for Flash/AIR

XML to ASCII

Convert XML data to ASCII table format with borders and alignment

About SQL to Textile Converter

Convert SQL database dumps (CREATE TABLE and INSERT statements) to Textile table markup format. Perfect for Redmine, Textpattern, and other Textile-based content management systems and wikis.

Key Features

  • Header Support: Optional header row with |_. syntax
  • Cell Alignment: Left (<.), center (=.), or right (>.) alignment
  • Special Character Escaping: Properly escapes Textile markup characters
  • Compatible Systems: Redmine, Textpattern, and other Textile-based platforms
  • Smart Parsing: Extracts column names and data from SQL dumps
  • File Download: Save as .textile file

How to Use

  1. Input SQL Data: Paste your SQL CREATE TABLE and INSERT statements or upload a .sql file
  2. Configure Options: Toggle header row and select cell alignment
  3. Copy or Download: Use the Copy or Download button to save your Textile markup

Textile Alignment Options

  • Left (<.): Align cell content to the left (default)
  • Center (=.): Center cell content
  • Right (>.): Align cell content to the right

Example Conversion

SQL Input:

CREATE TABLE products (
  id INT,
  name VARCHAR(100),
  price DECIMAL(10,2)
);

INSERT INTO products VALUES (1, 'Laptop', 999.99);
INSERT INTO products VALUES (2, 'Mouse', 24.99);

Textile Output (with header):

|_<. id|_<. name|_<. price|
|<. 1|<. Laptop|<. 999.99|
|<. 2|<. Mouse|<. 24.99|

Common Use Cases

  • Redmine: Create tables in Redmine wiki pages and issues
  • Textpattern: Format content for Textpattern CMS
  • Documentation: Generate tables for Textile-based documentation
  • Forums: Create tables in Textile-enabled forums
  • Wikis: Add structured data to Textile wikis
  • Content Migration: Convert database data to Textile format

Textile Table Syntax

Textile uses the following syntax for tables:

  • |_. Header: Creates a header cell
  • <. Left: Left-aligned cell
  • =. Center: Center-aligned cell
  • >. Right: Right-aligned cell
  • | Separator: Separates cells

Compatible Platforms

  • Redmine: Project management and issue tracking
  • Textpattern: Content management system
  • Textile Wikis: Various wiki platforms using Textile
  • Custom Applications: Any system supporting Textile markup

Supported SQL Syntax

  • CREATE TABLE: Extracts column names for table headers
  • INSERT INTO: Parses data values for table rows
  • Data Types: Handles all SQL data types (VARCHAR, INT, DECIMAL, etc.)
  • Quoted Strings: Handles single and double quotes with proper escaping
  • NULL Values: Displayed as empty cells

Privacy & Security

All conversions happen locally in your browser. Your SQL data is never uploaded to any server, ensuring complete privacy and security.

FAQ

Does this tool run the SQL on a database?

No. The converter only parses the SQL text (CREATE TABLE and INSERT statements) and turns it into Textile table markup. It never connects to or modifies any database.

Which platforms can use the generated Textile?

The output is standard Textile table syntax and works in Redmine, Textpattern, and most other Textile-enabled wikis, forums, and CMSs.

How are special characters handled?

Characters that have special meaning in Textile (such as |, *, _, and others) are escaped so that your data is displayed literally and does not break the table structure.

What happens to NULL values?

SQL NULL values are rendered as empty cells in the Textile table, matching how many documentation and wiki systems display missing data.

Is my SQL or Textile output sent anywhere?

No. All parsing and Textile generation run entirely in your browser. Neither your SQL input nor the generated Textile markup is uploaded to a server.