Search Results for "sql to csv" - Page 2
Sort By:
Showing 243 open source projects for "sql to csv"
View related business solutions-
Get full visibility and control over your tasks and projects with Wrike.Wrike offers world-class features that empower cross-functional, distributed, or growing teams take their projects from the initial request stage all the way to tracking work progress and reporting results.
-
The AI-powered unified PSA-RMM platform for modern MSPs.SuperOps.ai is the only PSA-RMM platform powered by intelligent automation and thoughtfully crafted for the new-age MSP. The platform also helps MSPs manage their projects, clients, and IT documents from a single place.
-
1
generatedata
A powerful, feature-rich, random test data generator
...The script is essentially an engine to generate any sort of random data in any format. It currently comes with 30 or so Data Types (types of data it generates), 12 Export Types (formats for the data, like CSV, SQL, JSON), plus around 32 data sets for specific countries (city names, regions, etc). But more importantly, it can be extended in any way you want. Check out the developer documentation for more information on that. The current major version of the script is 4.x, which was a big change over earlier releases. Earlier versions were written in PHP and MYSQL and 3.x offered a REST API to let you generate the data programmatically rather than via an API. ... -
2
AWS SDK for pandas
Easy integration with Athena, Glue, Redshift, Timestream, Neptune
aws-sdk-pandas (formerly AWS Data Wrangler) bridges pandas with the AWS analytics stack so DataFrames flow seamlessly to and from cloud services. With a few lines of code, you can read from and write to Amazon S3 in Parquet/CSV/JSON/ORC, register tables in the AWS Glue Data Catalog, and query with Amazon Athena directly into pandas. The library abstracts efficient patterns like partitioning, compression, and vectorized I/O so you get performant data lake operations without hand-rolling boilerplate. It also supports Redshift, OpenSearch, and other services, enabling ETL tasks that blend SQL engines and Python transformations. ... -
3
sparklyr
R interface for Apache Spark
sparklyr is an R package that provides seamless interfacing with Apache Spark clusters—either local or remote—while letting users write code in familiar R paradigms. It supplies a dplyr-compatible backend, Spark machine learning pipelines, SQL integration, and I/O utilities to manipulate and analyze large datasets distributed across cluster environments. -
4
AI Data Science Team
An AI-powered data science team of agents
AI Data Science Team is a Python library and agent ecosystem designed to accelerate and automate common data science workflows by modeling them as specialized AI “agents” that can be orchestrated to perform tasks like data cleaning, transformation, analysis, visualization, and machine learning. It provides a modular agent framework where each agent focuses on a step in the typical data science pipeline — for example, loading data from CSV/Excel files, cleaning and wrangling messy datasets, engineering predictive features, building models with AutoML, connecting to SQL databases, and producing visual outputs — all driven by natural language or programmatic instructions. The project includes ready-to-use applications that showcase these agents in action, such as an exploratory data analysis copilot that generates reports, a pandas data analyst that combines wrangling and plotting, and SQL database agents that can query business databases and output results directly. -
Securden Privileged Account ManagerDiscover and manage administrator, service, and web app passwords, keys, and identities. Automate management with approval workflows. Centrally control, audit, monitor, and record all access to critical IT assets.
-
5
OctoSQL
Join, analyse and transform data from multiple databases
OctoSQL is predominantly a CLI tool which lets you query a plethora of databases and file formats using SQL through a unified interface, even do JOINs between them. (Ever needed to join a JSON file with a PostgreSQL table? OctoSQL can help you with that.) OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. At the same time it's an easily extensible full-blown dataflow engine, and you can use it to add a SQL interface to your own applications. ... -
6
dataline
AI data analysis and visualization on CSV, Postgres, MySQL, Snowflake
dataline is an open-source AI data analysis and visualization platform that allows users to interact with datasets using natural language. The system enables both technical and non-technical users to explore data by asking questions conversationally, which the platform translates into database queries and analytical operations. It supports connections to multiple structured data sources such as PostgreSQL, MySQL, Snowflake, SQLite, Excel files, CSV datasets, and other database systems. Once... -
7
Quadratic
Data science spreadsheet with Python & SQL
...Quadratic is a Web-based spreadsheet application that runs in the browser and as a native app (via Electron). Our goal is to build a spreadsheet that enables you to pull your data from its source (SaaS, Database, CSV, API, etc) and then work with that data using the most popular data science tools today (Python, Pandas, SQL, JS, Excel Formulas, etc). Quadratic has no environment to configure. The grid runs entirely in the browser with no backend service. This makes our grids completely portable and very easy to share. Quadratic has Python library support built-in. ... -
8
World countries JSON
Constantly updated lists of world countries
Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP, SQL and XML formats, in multiple languages and with national flags included; also available are the ISO 3166-2 codes of provinces/ states associated with the countries. Also available are the ISO 3166-2 codes used for identifying the principal subdivisions (e.g., provinces or states) of all countries coded in ISO 3166-1. -
9
Dolt
Dolt, it's Git for data
Dolt is a SQL database that you can fork, clone, branch, merge, push and pull just like a git repository. Connect to Dolt just like any MySQL database to run queries or update the data using SQL commands. Use the command line interface to import CSV files, commit your changes, push them to a remote, or merge your teammate's changes. All the commands you know for Git work exactly the same for Dolt. -
The Secure And Reliable File Transfer Solution That You Control.Cerberus offers a variety of secure file transfer solutions to fit businesses of any size or business sector, including finance, technology, education, publishing, law offices, local, state, and federal government agencies, hospitals and many more.
-
10
pgweb
Cross-platform client for PostgreSQL databases
Pgweb is a web-based, cross-platform PostgreSQL database browser written in Go. Go was used in backend development in order to utilize the ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build a very simple and portable application to work with local or remote PostgreSQL databases. -
11
Kotlin Dataframe
Structured data processing in Kotlin
Data frame is an abstraction for working with structured data. Essentially it’s a 2-dimensional table with labeled columns of potentially different types. You can think of it like a spreadsheet or SQL table, or a dictionary of series objects. The handiness of this abstraction is not in the table itself but in a set of operations defined on it. The Kotlin Dataframe library is an idiomatic Kotlin DSL defining such operations. The process of working with data frame is often called data... -
12
manticoresearch
Easy to use open source fast database for search
...Can sync from MySQL/PostgreSQL/ODBC/xml/csv out of the box. Not fully ACID-compliant, but supports transactions and binlog for safe writes. -
13
CyberScraper 2077
A Powerful web scraper powered by LLM | OpenAI, Gemini & Ollama
CyberScraper 2077 is not just another web scraping tool – it's a glimpse into the future of data extraction. Born from the neon-lit streets of a cyberpunk world, this AI-powered scraper uses OpenAI, Gemini and LocalLLM Models to slice through the web's defenses, extracting the data you need with unparalleled precision and style. -
14
DataProfiler
Extract schema, statistics and entities from datasets
DataProfiler is an AI-powered tool for automatic data analysis and profiling, designed to detect patterns, anomalies, and schema inconsistencies in structured and unstructured datasets. The DataProfiler is a Python library designed to make data analysis, monitoring, and sensitive data detection easy. Loading Data with a single command, the library automatically formats & loads files into a DataFrame. Profiling the Data, the library identifies the schema, statistics, entities (PII / NPI), and... -
15
ROAPI
Create full-fledged APIs for slowly moving datasets without writing
...ROAPI automatically spins up read-only APIs and query frontends for slowly moving datasets without requiring you to write a single line of code. It builds on top of Apache Arrow and Datafusion. Query frontends to translate SQL, GraphQL and REST API queries into Datafusion plans. Datafusion for query plan execution. Data layer to load datasets from a variety of sources and formats with automatic schema inference. Response encoding layer to serialize intermediate Arrow record batch into various formats requested by the client. Its pluggable query core design makes it possible for users to efficiently perform join queries across a diverse set of data sources from simple CSV/Parquet files in Data warehouses to MySQL/Postgres, to SASS-like Google spreadsheets. -
16
Python 100 Days
Python - From Novice to Master in 100 Days
...It starts with foundational syntax, control flow, data structures, and functions, then advances through object-oriented programming, file I/O, exceptions, and modules. The middle sections focus on real-world Python applications, including working with CSV, Excel, Word, PowerPoint, PDFs, images, email/SMS, and regular expressions. The curriculum expands into databases and SQL, Linux essentials, web fundamentals, and a substantial Practical Django track that covers ORM, sessions, RESTful APIs, caching with Redis, asynchronous tasks with Celery, authentication, testing, and deployment. ... -
17
Sloc Cloc and Code (scc)
Sloc, Cloc and Code: scc is a very fast accurate code counter
Sloc, Cloc and Code: scc is a very fast accurate code counter with complexity calculations and COCOMO estimates written in pure Go. The tool is similar to cloc, sloccount and tokei. For counting the lines of code, blank lines, comment lines, and physical lines of source code in many programming languages. The goal is to be the fastest code counter possible, but also perform COCOMO calculations like sloccount, estimate code complexity similar to cyclomatic complexity calculators, and produce... -
18
A read-only JDBC driver for Java that uses Comma Separated Value (CSV) files as database tables. Ideal for writing data import programs and conversion programs.
-
19
LinkChecker
Check links in web documents or full websites
LinkChecker is a free, GPL licensed website validator. LinkChecker checks links in web documents or full websites. It runs on Python 3 systems, requiring Python 3.8 or later. The version in the pip repository may be old, to find out how to get the latest code, plus platform-specific information and other advice see doc/install.txt in the source code archive. If you do not want to install any additional libraries/dependencies you can use the Docker image which is published on GitHub... -
20
querycsv
A command line application to query files csv files with sql
-
21
mymssqldump
A tool to dump data from SQL Server in text format
SQL Server is sometimes difficult to get data from i some generic format, such as CSV. This program does just that. It allows SQL Server and Sybase (but this is not tested) tables to be exported in a variety of formats, including JSON, CSV and MySQL / MariaDB. -
22
WagLabel Barcode Label Printing Software
WagLabel is an advanced Barcode Labeling Software
WagLabel is a powerful barcode label software that helps businesses easily create, customize, and print professional barcode labels in seconds. Import data from Excel, CSV, SQL and Oracle databases. Designed for speed, accuracy, and flexibility, WagLabel supports all major 1D (linear) and 2D barcode formats, making it the ideal solution for product labeling, inventory management, logistics, retail, and manufacturing. With an intuitive interface and high-performance barcode engine, WagLabel enables users to generate high-resolution barcode labels quickly—without technical complexity. -
23
pyDaSSQLiteMan
An easy way to manage SQLite databases and query CSV files
Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files. If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ . I'd recommend something after version 3. Testing has been Windows based. SQLite is a free database format released into the public domain. See http://www.sqlite.org/ Please check out the Wiki Home page https://sourceforge.net/p/pycsvdb/wiki/Home/ and the General Help page (https://sourceforge.net/p/pycsvdb/wiki/General%20Help/) to find extra information and help. ... -
24
ISQLHelper
SQL Server Helping Application For Developers
1.SQL Compare Compare and synchronize SQL Server database schemas effortlessly. 2.SQL Data Compare Identify and sync data differences between SQL Server databases. 3.Folder to SQL Compare Compare SQL script folders with live SQL Server databases. 4.SQL Trace / SQL Profiler (Azure Supported) Capture, trace, and analyze SQL Server events and performance — includes Azure SQL support. 5.SQL Table Documents Generate structured documentation for SQL Server table schemas. 6.SQL Data Export Export SQL Server data into multiple formats (CSV, Excel, JSON, etc.). 7.Excel to SQL Move Import Excel spreadsheets directly into SQL Server tables. 8.Import / Export Data Perform high-speed bulk data transfer between databases and formats. 9.Daily Tasks Automate and schedule routine SQL Server maintenance tasks. 10.Procedure Creation Easily design, edit, and manage stored procedures. 11.Script Maintenance Organize, version, and manage SQL scripts within the applica -
25
ART
A Reporting Tool
ART is a reporting and business intelligence solution. It enables quick deployment of SQL query results. Supports tabular reports, charts, dashboards, scheduling. Support https://areportingtool.com/support/
