Best Gemini prompts for Library Technicians

Given a complex search query with multiple parameters and a large dataset, write a step-by-step plan to optimize the query for faster execution times, including indexing strategies, data partitioning, and query rewriting, and provide examples of how to implement these optimizations in a major database management system like MySQL or PostgreSQL, taking into account the specific requirements of a library's cataloging system and the need to minimize errors and ensure data consistency.

Design a workflow to automate the creation and distribution of daily status reports using Google Workspace, including the use of Google Sheets to collect data, Google Docs to generate the report, and Google Drive to store and share the final document, and provide detailed instructions on how to set up the workflow using Google Apps Script, including error handling and notification systems to ensure timely delivery of the reports to library administrators.

Analyze a dataset of error rates for a specific task, such as cataloging or circulation, and identify the most common causes of errors, including data entry mistakes, software glitches, and procedural misunderstandings, and provide recommendations for addressing these errors, including staff training, process improvements, and technology upgrades, and create a sample Quality Audit report to document the findings and proposed solutions, taking into account the library's existing SOPs and quality control measures.

Develop a plan to integrate a task tracking system, such as Trello or Asana, with a library's existing communication platform, such as Microsoft Teams or Slack, to enable seamless task assignment, tracking, and notification, including the use of APIs or Zapier to connect the systems, and provide step-by-step instructions on how to set up the integration, including customization of workflows, boards, and lists to fit the library's specific needs and staffing structure, and discuss potential issues with data consistency and error handling across the integrated systems.