SQL Formatter

Format SQL code instantly. Beautify SQL, indent properly, validate syntax, and make code readable. Perfect for developers!
Enter SQL Code:
                    <div class="option-group">
                        <label class="option-label">Indentation:</label>
                        <select id="indentType" class="option-input">
                            <option value="2">2 Spaces</option>
                            <option value="4" selected>4 Spaces</option>
                            <option value="8">8 Spaces</option>
                            <option value="tab">Tab</option>
                        </select>
                    </div>
                    <div class="option-group">
                        <label class="option-label">Keyword Case:</label>
                        <select id="keywordCase" class="option-input">
                            <option value="upper" selected>UPPERCASE</option>
                            <option value="lower">lowercase</option>
                            <option value="title">Title Case</option>
                        </select>
                    </div>
                    <div class="option-group">
                        <label class="option-label">Line Breaks:</label>
                        <select id="lineBreaks" class="option-input">
                            <option value="auto" selected>Auto</option>
                            <option value="always">Always</option>
                            <option value="never">Never</option>
                        </select>
                    </div>
                    <div class="option-group">
                        <label class="option-label">Max Line Length:</label>
                        <input type="number" id="maxLineLength" class="option-input" value="100" min="40" max="200">
                    </div>
                </div>

                <div class="btn-group">
                    <button id="formatBtn" class="btn">Format SQL</button>
                    <button id="minifyBtn" class="btn btn-secondary">Minify SQL</button>
                    <button id="validateBtn" class="btn btn-secondary">Validate SQL</button>
                    <button id="clearBtn" class="btn btn-secondary">Clear All</button>
                </div>
            </div>

            <!-- Results -->
            <div class="results-section">
                <div class="results-header">
                    <h3 class="results-title">Formatted SQL:</h3>
                    <button id="copyBtn" class="copy-btn">Copy to Clipboard</button>
                </div>
                <pre id="formattedOutput" class="formatted-code">Your formatted SQL code will appear here...</pre>
            </div>

            <!-- Stats -->
            <div class="stats-section">
                <div class="stat-card">
                    <div class="stat-value" id="lineCount">0</div>
                    <div class="stat-label">Lines</div>
                </div>
                <div class="stat-card">
                    <div class="stat-value" id="charCount">0</div>
                    <div class="stat-label">Characters</div>
                </div>
                <div class="stat-card">
                    <div class="stat-value" id="keywordCount">0</div>
                    <div class="stat-label">Keywords</div>
                </div>
                <div class="stat-card">
                    <div class="stat-value" id="tableCount">0</div>
                    <div class="stat-label">Tables</div>
                </div>
            </div>
        </div>
    </main>

    <!-- Footer -->
    <footer class="footer">
        <div class="container">
            <p>© 2024 FreeDownloadTools.com. All rights reserved. Made with ❤️ for creators worldwide.</p>
            <p><strong>Powered by <a href="https://likeprovider.net" target="_blank">LikeProvider.net</a></strong></p>
        </div>
    </footer>

    <script defer>
        // SQL Formatter Tool
        class SQLFormatter {
            constructor() {
                this.initializeElements();
                this.bindEvents();
            }

            initializeElements() {
                this.sqlInput = document.getElementById('sqlInput');
                this.formattedOutput = document.getElementById('formattedOutput');
                this.formatBtn = document.getElementById('formatBtn');
                this.minifyBtn = document.getElementById('minifyBtn');
                this.validateBtn = document.getElementById('validateBtn');
                this.clearBtn = document.getElementById('clearBtn');
                this.copyBtn = document.getElementById('copyBtn');
                this.indentType = document.getElementById('indentType');
                this.keywordCase = document.getElementById('keywordCase');
                this.lineBreaks = document.getElementById('lineBreaks');
                this.maxLineLength = document.getElementById('maxLineLength');
                
                // Stats elements
                this.lineCount = document.getElementById('lineCount');
                this.charCount = document.getElementById('charCount');
                this.keywordCount = document.getElementById('keywordCount');
                this.tableCount = document.getElementById('tableCount');
            }

            bindEvents() {
                this.formatBtn.addEventListener('click', () => this.formatCode());
                this.minifyBtn.addEventListener('click', () => this.minifyCode());
                this.validateBtn.addEventListener('click', () => this.validateCode());
                this.clearBtn.addEventListener('click', () => this.clearAll());
                this.copyBtn.addEventListener('click', () => this.copyToClipboard());
                this.sqlInput.addEventListener('input', () => this.updateStats());
            }

            formatCode() {
                const code = this.sqlInput.value.trim();
                if (!code) {
                    this.showError('Please enter some SQL code to format.');
                    return;
                }

                try {
                    const formatted = this.beautifySQL(code);
                    this.formattedOutput.textContent = formatted;
                    this.updateStats();
                    this.showSuccess('SQL code formatted successfully!');
                } catch (error) {
                    this.showError('Error formatting SQL: ' + error.message);
                }
            }

            minifyCode() {
                const code = this.sqlInput.value.trim();
                if (!code) {
                    this.showError('Please enter some SQL code to minify.');
                    return;
                }

                try {
                    const minified = this.minifySQL(code);
                    this.formattedOutput.textContent = minified;
                    this.updateStats();
                    this.showSuccess('SQL code minified successfully!');
                } catch (error) {
                    this.showError('Error minifying SQL: ' + error.message);
                }
            }

            validateCode() {
                const code = this.sqlInput.value.trim();
                if (!code) {
                    this.showError('Please enter some SQL code to validate.');
                    return;
                }

                try {
                    // Basic SQL validation
                    const sqlKeywords = ['SELECT', 'FROM', 'WHERE', 'INSERT', 'UPDATE', 'DELETE', 'CREATE', 'DROP', 'ALTER', 'JOIN', 'INNER', 'LEFT', 'RIGHT', 'OUTER', 'GROUP BY', 'ORDER BY', 'HAVING'];
                    const hasKeyword = sqlKeywords.some(keyword => code.toUpperCase().includes(keyword));
                    
                    if (hasKeyword) {
                        this.showSuccess('SQL syntax appears to be valid!');
                    } else {
                        this.showError('No valid SQL keywords found.');
                    }
                } catch (error) {
                    this.showError('SQL validation error: ' + error.message);
                }
            }

            beautifySQL(sql) {
                // Simple SQL beautifier
                let formatted = sql;
                
                // Convert keywords to specified case
                const keywordCase = this.keywordCase.value;
                const sqlKeywords = ['SELECT', 'FROM', 'WHERE', 'INSERT', 'UPDATE', 'DELETE', 'CREATE', 'DROP', 'ALTER', 'JOIN', 'INNER', 'LEFT', 'RIGHT', 'OUTER', 'GROUP BY', 'ORDER BY', 'HAVING', 'AND', 'OR', 'NOT', 'IN', 'EXISTS', 'BETWEEN', 'LIKE', 'IS', 'NULL', 'AS', 'ON', 'USING'];
                
                sqlKeywords.forEach(keyword => {
                    const regex = new RegExp(`\\b${keyword}\\b`, 'gi');
                    if (keywordCase === 'upper') {
                        formatted = formatted.replace(regex, keyword.toUpperCase());
                    } else if (keywordCase === 'lower') {
                        formatted = formatted.replace(regex, keyword.toLowerCase());
                    } else if (keywordCase === 'title') {
                        formatted = formatted.replace(regex, keyword.charAt(0).toUpperCase() + keyword.slice(1).toLowerCase());
                    }
                });
                
                // Add line breaks after major keywords
                formatted = formatted.replace(/\b(SELECT|FROM|WHERE|INSERT|UPDATE|DELETE|CREATE|DROP|ALTER|JOIN|GROUP BY|ORDER BY|HAVING)\b/gi, '\n$1');
                
                // Add line breaks after commas
                formatted = formatted.replace(/,/g, ',\n');
                
                // Add line breaks after operators
                formatted = formatted.replace(/\b(AND|OR)\b/gi, '\n$1');
                
                // Clean up multiple line breaks
                formatted = formatted.replace(/\n\s*\n/g, '\n');
                
                // Add proper indentation
                const lines = formatted.split('\n');
                let indentLevel = 0;
                const indentSize = parseInt(this.indentType.value) || 4;
                const indentChar = this.indentType.value === 'tab' ? '\t' : ' '.repeat(indentSize);
                
                const indentedLines = lines.map(line => {
                    const trimmedLine = line.trim();
                    if (!trimmedLine) return '';
                    
                    // Decrease indent for certain keywords
                    if (trimmedLine.match(/\b(FROM|WHERE|GROUP BY|ORDER BY|HAVING)\b/i)) {
                        indentLevel = Math.max(0, indentLevel - 1);
                    }
                    
                    const indentedLine = indentChar.repeat(indentLevel) + trimmedLine;
                    
                    // Increase indent for certain keywords
                    if (trimmedLine.match(/\b(SELECT|INSERT|UPDATE|DELETE|CREATE|DROP|ALTER)\b/i)) {
                        indentLevel++;
                    }
                    
                    return indentedLine;
                });
                
                return indentedLines.join('\n');
            }

            minifySQL(sql) {
                // Simple SQL minifier
                return sql
                    .replace(/--.*$/gm, '') // Remove line comments
                    .replace(/\/\*[\s\S]*?\*\//g, '') // Remove block comments
                    .replace(/\s+/g, ' ') // Replace multiple spaces with single space
                    .replace(/\s*([,;()])\s*/g, '$1') // Remove spaces around punctuation
                    .trim();
            }

            updateStats() {
                const code = this.sqlInput.value;
                const lines = code.split('\n').length;
                const chars = code.length;
                const keywords = (code.match(/\b(SELECT|FROM|WHERE|INSERT|UPDATE|DELETE|CREATE|DROP|ALTER|JOIN|GROUP BY|ORDER BY|HAVING|AND|OR|NOT|IN|EXISTS|BETWEEN|LIKE|IS|NULL|AS|ON|USING)\b/gi) || []).length;
                const tables = (code.match(/\bFROM\s+(\w+)/gi) || []).length + (code.match(/\bJOIN\s+(\w+)/gi) || []).length;

                this.lineCount.textContent = lines;
                this.charCount.textContent = chars;
                this.keywordCount.textContent = keywords;
                this.tableCount.textContent = tables;
            }

            clearAll() {
                this.sqlInput.value = '';
                this.formattedOutput.textContent = 'Your formatted SQL code will appear here...';
                this.updateStats();
            }

            async copyToClipboard() {
                const text = this.formattedOutput.textContent;
                if (text === 'Your formatted SQL code will appear here...') {
                    this.showError('No formatted code to copy.');
                    return;
                }

                try {
                    await navigator.clipboard.writeText(text);
                    this.showSuccess('Code copied to clipboard!');
                } catch (error) {
                    // Fallback for older browsers
                    const textArea = document.createElement('textarea');
                    textArea.value = text;
                    document.body.appendChild(textArea);
                    textArea.select();
                    document.execCommand('copy');
                    document.body.removeChild(textArea);
                    this.showSuccess('Code copied to clipboard!');
                }
            }

            showSuccess(message) {
                this.showNotification(message, 'success');
            }

            showError(message) {
                this.showNotification(message, 'error');
            }

            showNotification(message, type) {
                // Remove existing notifications
                const existing = document.querySelector('.notification');
                if (existing) existing.remove();

                const notification = document.createElement('div');
                notification.className = `notification notification-${type}`;
                notification.textContent = message;
                notification.style.cssText = `
                    position: fixed;
                    top: 20px;
                    right: 20px;
                    padding: 1rem 1.5rem;
                    border-radius: 10px;
                    color: white;
                    font-weight: 600;
                    z-index: 10000;
                    animation: slideIn 0.3s ease;
                    background: ${type === 'success' ? 'var(--success)' : '#dc3545'};
                `;

                document.body.appendChild(notification);

                setTimeout(() => {
                    notification.style.animation = 'slideOut 0.3s ease';
                    setTimeout(() => notification.remove(), 300);
                }, 3000);
            }
        }

        // Initialize the formatter when the page loads
        document.addEventListener('DOMContentLoaded', () => {
            new SQLFormatter();
        });

        // Add CSS animations
        const style = document.createElement('style');
        style.textContent = `
            @keyframes slideIn {
                from { transform: translateX(100%); opacity: 0; }
                to { transform: translateX(0); opacity: 1; }
            }
            @keyframes slideOut {
                from { transform: translateX(0); opacity: 1; }
                to { transform: translateX(100%); opacity: 0; }
            }
        `;
        document.head.appendChild(style);
    </script>
<!-- Mobile Menu Script --><script defer>document.addEventListener("DOMContentLoaded", function() { const mobileMenuToggle = document.querySelector(".mobile-menu-toggle"); const navLinks = document.querySelector(".nav-links"); if (mobileMenuToggle && navLinks) { mobileMenuToggle.addEventListener("click", function() { mobileMenuToggle.classList.toggle("active"); navLinks.classList.toggle("active"); }); navLinks.addEventListener("click", function(e) { if (e.target.tagName === "A") { mobileMenuToggle.classList.remove("active"); navLinks.classList.remove("active"); } }); document.addEventListener("click", function(e) { if (!mobileMenuToggle.contains(e.target) && !navLinks.contains(e.target)) { mobileMenuToggle.classList.remove("active"); navLinks.classList.remove("active"); } }); } });</script></body>
</html>