app.py

import gradio as gr
import duckdb

db = duckdb.connect('test.db')

def greet(name):
    return "Hello " + name + "!! There are " + str(db.execute('show tables;').df().shape[0]) + ' tables' 

demo = gr.Interface(fn=greet, inputs="text", outputs="text")
demo.launch()