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

Textile Output

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.