Inouts
HomeExploreAboutContact
Log inSign upAdd Service
Examples FeedCategoriesTasksIns & Outs
Privacy PolicyCookies

© 2026 Inouts. All rights reserved.

Defog.ai logo

Defog

by Defog.ai

Popularity

2 out of 5 levels

about 20K users per month
Visit

Service information

Plans

freepaid

Platforms

websiteAPI

Requirements

email requiredaccount registration required

On This Page

    Description

    Defog.ai is an online service that generates natural language data queries, available through website or API. It supports over 50 languages, and can be used to add conversational AI widgets to your app. Obstacles include email and account registration.

    💡🔍
    generate query

    Examples

    🔍💡

    Generate Query

    #1
    inputs
    outputs

    SELECT

    CUSTOMERS.CUSTOMER_NAME,

    COUNT(CASE WHEN RENT_PAID_DATE <= RENT_DUE_DATE THEN 1 END) / COUNT(*) * 100 AS "Percentage of Rent Paid on Time"

    FROM

    APPFOLIO_TEST.PUBLIC.RENT_DUE

    JOIN APPFOLIO_TEST.PUBLIC.CUSTOMERS ON RENT_DUE.CUSTOMER_ID = CUSTOMERS.CUSTOMER_ID

    GROUP BY

    CUSTOMERS.CUSTOMER_NAME;

    image
    #2
    inputs
    outputs
    image

    SELECT c.customer_id, c.customer_name, c.contract_arr, SUM(e.notifications_received) AS notifications_received, SUM(e.notifications_opened) AS notifications_opened, SUM(e.notifications_replied) AS notifications_replied, (SUM(e.notifications_received) + SUM(e.notifications_opened) + SUM(e.notifications_replied)) / c.contract_arr AS value_for_money

    FROM the-broadline.notification_events.events AS e

    INNER JOIN the-broadline.notification_events.customers AS c

    ON e.customer_id = c.customer_id

    GROUP BY c.customer_id, c.customer_name, c.contract_arr

    ORDER BY value_for_money DESC

    ;

    image
    #3
    inputs
    outputs

    SELECT c.customer_name, c.contract_arr, SUM(e.notifications_attempted) AS notifications_attempted, SUM(e.notifications_failed) AS notifications_failed, SUM(e.notifications_failed) / SUM(e.notifications_attempted) AS failure_rate

    FROM the-broadline.notification_events.events AS e

    INNER JOIN the-broadline.notification_events.customers AS c

    ON e.customer_id = c.customer_id

    WHERE DATE(e.hour) >= DATE_SUB(CURRENT_DATE(), INTERVAL 3 MONTH)

    GROUP BY c.customer_name, c.contract_arr

    ORDER BY failure_rate DESC

    ;

    #4
    inputs
    outputs

    SELECT c.customer_name, c.contract_arr, SUM(e.notifications_attempted) AS notifications_attempted, SUM(e.notifications_failed) AS notifications_failed, SUM(e.notifications_failed) / SUM(e.notifications_attempted) AS failure_rate

    FROM the-broadline.notification_events.events AS e

    INNER JOIN the-broadline.notification_events.customers AS c

    ON e.customer_id = c.customer_id

    WHERE DATE(e.hour) >= DATE_SUB(CURRENT_DATE(), INTERVAL 3 MONTH)

    GROUP BY c.customer_name, c.contract_arr

    ORDER BY failure_rate DESC

    ;

    Features

    • Defog comes with predefined datasets.
    • It has fine-tuned models specifically for different database schemas.
    • It supports complex SQL queries.
    • Defog adheres to custom metrics and industry codes.
    • It ensures data privacy and has a feature for regression detection.

    Perfect for

    • Data analysts would find Defog useful.
    • Database administrators can benefit from using it.
    • Enterprise workflow managers might find it handy.

    Similar services

    SQL query builder preview
    SQL query builder logo
    SQL query builder
    Defog.ai preview
    Defog.ai logo
    Defog.ai
    SQLthroughAI preview
    SQLtroughAI Text to SQL logo
    SQLthroughAI
    AIHelperBot preview
    Generate SQL Queries With AI ! logo
    AIHelperBot
    Share this page: