BestPromptFinder

Below is an instruction that describes a task. Write a respo...

The prompt

Below is an instruction that describes a task. Write a response that appropriately completes the request. ### Instruction: Develop an API in Python that fetches data from an SQL database and presents the data in the form of a JSON. ### Input: None ### Output: import json import sqlite3 from flask import Flask, request, jsonify app = Flask(__name__) def dict_factory(cursor, row): d = {} for idx, col in enumerate(cursor.description): d[col[0]] = row[idx] return d @app.route('/', methods=['GET']) def index(): connection = sqlite3.connect('database.db') connection.row_factory = dict_factory cur = connection.cursor() all_users = cur.execute('SELECT * FROM users;').fetchall() return jsonify(all_users) if __name__ == '__main__': app.run(debug = True)

Why this prompt

• AI-graded 42/100 for quality and structure
• Reusable template — swap in {LOCATION}
• 89% found it useful across Gemini, GPT-5.6, Claude

Source

Hugging Face

Related Coding prompts